Pricing changes are coming in January. Contact our Sales team to secure the current price for your desired license.

how to identify if i have expanded cell or drill down on cell

Answered
Deepak Krishnan asked on March 19, 2024

Hi, 
When using the cellclick event , how to identify if i have expanded cell or drill down on cell ? 
 

Nadia Khodakivska created this ticket from #61642

4 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster March 21, 2024

Hello Deepak,

Thank you for the question.

We recommend using the cell.collapsed and cell.drilledUp properties of the CellDataObject. This way, if cell.collapsed is true, it means that the clicked cell is expanded after the click. The same with cell.drilledUp - if it is set to true, the cell will be drilled down.

Please let us know if it works for you. Looking forward to hearing from you.

Kind regards,
Nadia

Public
Deepak Krishnan March 21, 2024

Hi , I was using cell.drilledup and cell.collapsed, but it is not working as expected. When i drilldown both cell.drilledup and cell.collapsed is true, same when i expand a cell. So, im not able to differentiate.

This is the cellDataObject when i clicked on drilldown - 

{
"columnIndex": 0,
"columns": [],
"label": "USA",
"escapedLabel": "USA",
"measure": null,
"hierarchy": {
"caption": "Store",
"dimensionCaption": "Store Country",
"dimensionUniqueName": "Store",
"folder": "",
"label": "Store",
"levels": [
{
"uniqueName": "Store Country",
"caption": "Store Country"
},
{
"uniqueName": "Store State",
"caption": "Store State"
},
{
"uniqueName": "Store City",
"caption": "Store City"
},
{
"uniqueName": "Store Name",
"caption": "Store Name"
}
],
"sort": "asc",
"uniqueName": "Store",
"type": "level"
},
"member": {
"uniqueName": "store.[usa]",
"caption": "USA",
"dimensionName": "Store",
"hierarchyName": "Store",
"hierarchyCaption": "Store",
"parentMember": "store.[(all member)]"
},
"rowIndex": 2,
"rows": [
{
"uniqueName": "store.[usa]",
"caption": "USA",
"dimensionName": "Store",
"hierarchyName": "Store",
"hierarchyCaption": "Store",
"parentMember": "store.[(all member)]"
}
],
"type": "header",
"value": null,
"expanded": false,
"collapsed": true,
"drilledUp": true,
"drilledDown": false,
"recordId": null,
"isTotal": true,
"isTotalRow": true,
"isTotalColumn": false,
"isClassicTotalRow": false,
"isGrandTotal": false,
"isGrandTotalRow": false,
"isGrandTotalColumn": false,
"isDrillThrough": false,
"level": 0,
"x": 25,
"y": 85,
"width": 120,
"height": 30
}
Public
Deepak Krishnan March 22, 2024

This happens when we have both expand and drilldown on same cell.

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster March 22, 2024

Hello Deepak,

Thank you for the response.

Yes, you are correct that both cell.collapsed and cell.drilledUp are set to true if the cell can be expanded and drilled down at the same time. Could you please provide us with more details on your use case? How do you want to use the information that the cell is expanded or collapsed on click? It would greatly help us.

Looking forward to hearing from you.

Kind regards,
Nadia

Please login or Register to Submit Answer