Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Creating a collapsible table in Qlik Sense?

Hello Everyone,

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.

Datasource

salarydata.PNG

Desired Output

salary.PNG

Thanks in advance

4 Replies
robert99
Valued Contributor II

Re: Creating a collapsible table in Qlik Sense?

Hi

Why don't you use the Pivot table

Not applicable

Re: Creating a collapsible table in Qlik Sense?

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.

wdqw.PNG

robert99
Valued Contributor II

Re: Creating a collapsible table in Qlik Sense?

"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

giakoum
Honored Contributor II

Re: Creating a collapsible table in Qlik Sense?

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

Community Browser