Discussion board where members can get started with Qlik Sense.
My Qlik Sense straight table is like:
Order Item SUM(sales)
1 A 300
1 B -
I want to show only the records with SUM(sales). In this case:
Since SUM(sales) is measure, so there is no "show null values" box. How should I write the functions for Order and Item dimensions?
Thanks for help!
Go to Solution.
Uncheck 'Include zero values' under Data Handling -> Add-Ons