Set Analyis expression with null handling

New-Qlik — Tue, 09 Apr 2019 10:01:47 GMT

Hi,

I want to create set analysis expression to show count as table heading .

I have used below expression as measure in table and it works

count(

if((isnull([ Year]) or [ Year]= $(vCurrent_FY)) and
(isnull([Flag]) or [Flag]= '1') and
[Master Flag]= '1'
code)

I am trying to add same as table title and don't know how to add and handle null expression

='Table title' & Num(Count({< [Master Flag] = {'1'},
[Flag]= {'1'}>} Distinct [Code]), '# ##0' )

Re: Set Analyis expression with null handling

sunny_talwar — Tue, 09 Apr 2019 11:35:04 GMT

Why don't you create a new flag in the script like this

If(Len(Trim(Year)) = 0 or Year = '$(vCurrent_FY)', 1, 0) as YearFlag,
If(Len(Trim(Flag)) = 0 or Flag = 1, 1, 0) as FlagFlag,

and then use it in your expression

='Table title' & 
Num(
Count({<[Master Flag] = {'1'}, [FlagFlag] = {'1'}, YearFlag = {'1'}>} DISTINCT [Code])
, '# ##0' )