Help on set analisys! - Qlik Community

Report Inappropriate Content · ‎2010-08-16

<body><p>How can i put a isnull filter on expression?</p> <p>I need something like this</p> <p> <p:colorscheme colors="#ffffff,#000000,#8c8c8c,#363636,#62ac1e,#2f7e20,#b1db1f,#595959"> <div class="O" v:shape="_x0000_s1026"><b>COUNT({$<DT_FIRED={ ???Where this date isnull???</b></span><b> }>} NR_EMPLOYE)</b></div> <div class="O" v:shape="_x0000_s1026"><b><br /></b></div> <div class="O" v:shape="_x0000_s1026"><b>tks a lot!!!</b></div> </p:colorscheme></p></body>

Report Inappropriate Content · ‎2010-08-16

It is supposed to be:

COUNT({$<DT_FIRED={''}>} NR_EMPLOYE)

The help also says that putting a value that is not found in the dataset will do, but I haven't really gotten that to work:

COUNT({$<DT_FIRED={'THISWONTMATCH'}>} NR_EMPLOYE)

Report Inappropriate Content · ‎2010-08-16

i will try....tks!!!!

Report Inappropriate Content · ‎2010-08-16

doesn´t work

DT_FIRED={' '}

Report Inappropriate Content · ‎2010-08-16

No space:

{''}

The version you typed tries to match DT_FIRED to a blank space. You want single quotes with no space in between.

Just looked at the help again and it says:

DT_FIRED={}

Give that a try.

EDIT: I recently had a similar requirement in one of my applications. In the end, I replaced the nulls with a different value in my load to simplify the Set Analysis.