Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Aditya_Chitale
Specialist
Specialist

How to restrict measures for particular column in pivot table

Hi all,

is it possible to restrict measures for selective columns in Qlik Sense pivot table ?

I have created a hard coded field in backend for showing Target and Actual column and separated measures using if() condition in set expression

Aditya_Chitale_0-1642662831870.png

Here, I want to show % SO Created AV Achieved field only under Actual column. Any way to achieve this ?

 

Regards,

Aditya

2 Replies
brunobertels
Master
Master

Hi 

Have you tried to uncheck the option "exclude null values" in the panel option ? 

Aditya_Chitale
Specialist
Specialist
Author

@brunobertels 

Yes did that but its not helping