Hide expressions in Pivot table

[#1]

Hi All

I want to create a pivot table and show certain expressions only under certain group.

For eg : In the attached file, I want to show Enterprise Infra Support, Personal Support etc under Fixed and Avamr, Projects under variable. I have used IF condition, still it is showing up under both.

Please advise.

[#2]

Hi,

As a work-around I added the "Extra Expression" as a calculated dimension.

BR,

/Yolanda

[#3]

Hi Yolanda,

Could you kindly let me know how you are able to make it into calcualted dimension? When I put in group function in the pivot table like sum, it will become an 'error in calcualted dimension'.
Also, in your case, how do u prevent "Expression 1","Expression 2","Expression 3" as sub level under "Extra Expression"?
Thanks!

Best Regards,

Crystal

[#4]

Hi Crystal,

I recommend you to read about aggr functionality. For example take a look at this post: http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/07/aggr

In my work-around I defined the "Extra Expression" as aggr(expression,dim1,dim2) and I placed it before dim3.

I hope this helps you!

Good luck!

/Yolanda

[#5]

Thanks very much, Yolanda!