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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
ruma_barman
Creator
Creator

Rows of pivot table to be displayed only for measures greater than 0 or null

Hi All,

Can anybody help on this?

There is a pivot table in qliksense where a dimension say A is added in rows and synthetic dimensions are added using valuelist in columns and measures are added for each synthetic dimensions.How to show only those rows which are having values i.e values of dimension A should only be displayed if the measures are not null or 0 .

Thanks,

Ruma

2 Replies
arulsettu
Master III
Master III

can you post sample app

ruma_barman
Creator
Creator
Author

Hi Arul,

One qvf is attached .It is working in my desktop when I use limitation.But in server it's not working i.e the dimensions are still visible whose value is null or 0. Do you know any other solution to fix this?

Thanks,

Ruma