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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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