Qlik Community

Ask a Question

App Development

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

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

Null issue in Set analysis

Hello Team ,

 

agastya_3-1626859029634.png

 

 

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|

@sunny_talwar 

0 Replies