Discussion board where members can get started with Qlik Sense.
I am working on a table that should be collapsible ,but I am not able to find any extension to support such functionality.
It would be of really great help if anyone of you can provide some insights regarding same.
Below is the excel snippet of my data and desired output for better understanding.
Thanks in advance
Why don't you use the Pivot table
Thanks for the reply @Robert Hutchings
Actually pivot is giving me option something like this, but I want different hierarchy, and also the calculation I am unable to do.
"but I want different hierarchy,"
Unsure what you mean?
"calculation I am unable to do."
It might be best to start another thread on this
You need to fix your data model a little.
You have New Joinee or Resigned/Retired as measures. If you change them to dimensions with a common field as measure. Then the pivot will look great