Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Sept. 16, Qlik Product Portfolio Strategy and Roadmap for Data Integration 11 AM ET REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

Null issue in Set analysis

Hello Team ,





Expression : Variable column Expression 

IF($(vAfterRev) >1,
Count(TOTAL<ss>{$<ss,OrderYear=,OrderMonth=,MonthYear = {"$(='>=' & Date(MonthStart(Max(MonthYear), -12), 'MMM-YYYY') & '<=' & Date(Max(MonthYear)-1,'MMM-YYYY'))"}>} DISTINCT ss))

I want to exclude '-' from total counts but not sure if anything wrong in expression, expected value is sum of the column,

variable column  8 including Null values as well ,Count are based on last column greater then 1 then only there should be value variable column I.e 4 


Ouput Table:

|Column 1|Variable |

|Eue            | 4|


0 Replies