Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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