Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide expressions in Pivot table

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.

13 Replies
sujeetsingh
Master III
Master III

Try Expression Grouping if possible

Not applicable
Author

Can u pls elaborate

Not applicable
Author

Hi Paramita Sahu,

Did you get a work-around to this question? I am having exactly the same requirement!

Thank you in advance,

/Yolanda

ashfaq_haseeb
Champion III
Champion III

Hi,

To hide expression just give wrong calculated condition in Conditional value.

Have a look at attached image.

Regards

ASHFAQ

Not applicable
Author

Thank you Mohammed,

But this will hide the expression for all the dimensions. What I need is to hide the expresion for certain dimensions (I want some columns to appear only for a specific value of one of the dimesions).

BR,

/Yolanda

ashfaq_haseeb
Champion III
Champion III

Can you share sample application with Expected output

Regards

ASHFAQ

Not applicable
Author

Something like:

table_example.png

deepakqlikview_123
Specialist
Specialist

why u are not uncheck expression in expression tab.

Not applicable
Author

Hi Yolanda,

Have you solved the problem yet?

As I'm facing the same problem of hiding columns in pivot table, Thanks!

Best Regards,

Crystal