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: 
Not applicable

Selection of dimensions

I am new in QV and I need their help.

I have a list of categories that have associated to a quantity for month, the categories they are my dimensions, in a chart pivots and the quantities are my expressions.
As I can show alone the dimensions that have the biggest quantity that 0?.

Thanks

1 Reply
stephencredmond
Partner - Specialist II
Partner - Specialist II

Hi,

Something like this could work:


If(Sum(Value)<0,0,Sum(Value))


Then just make sure that the option to supress zero is on in Presentation.

Regards,

Stephen