asked on March 19, 2024
Hi,
When using the cellclick event , how to identify if i have expanded cell or drill down on cell ?
⋅ 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
⋅ 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
}
⋅ March 22, 2024
This happens when we have both expand and drilldown on same cell.
⋅ 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