Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am relatively new to Qlik and I am trying to work on a Pivot table. I have a loaded table that has a column named Employee status which has 4 values viz. Active, terminated, retired and transferred.
I wanted to build a pivot table based on all employees that have a status as 'Active'. Is there any way I can only pull those records into the pivot table?
Any help is appreciated.
Thanks!
In your expression's include this condition in your set analysis
Sum( {<[Employee Status] = {'Active'} >} <yourmeasure>)
That should do it for you. Other options if it needs to get more complicated:
- create a secondary field with just the values you want to display and use that dimension in the chart, suppress null values.
- create a calculated dimension aggr(only ( {<[Employee Status] = {'Active'} >} [Employee Status]) [Employee Status]) and suppress null values.
In your expression's include this condition in your set analysis
Sum( {<[Employee Status] = {'Active'} >} <yourmeasure>)
That should do it for you. Other options if it needs to get more complicated:
- create a secondary field with just the values you want to display and use that dimension in the chart, suppress null values.
- create a calculated dimension aggr(only ( {<[Employee Status] = {'Active'} >} [Employee Status]) [Employee Status]) and suppress null values.