Help with Pivot tables

[sanp96]

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!

[stevejoyce · Accepted solution]

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.