topic Help on set analisys! in QlikView

Help on set analisys!

Mon, 16 Aug 2010 20:02:11 GMT

<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>

Help on set analisys!

Mon, 16 Aug 2010 20:05:45 GMT

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)

Help on set analisys!

Mon, 16 Aug 2010 20:14:07 GMT

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

Help on set analisys!

Mon, 16 Aug 2010 20:20:45 GMT

doesn´t work

DT_FIRED={' '}

Help on set analisys!

Mon, 16 Aug 2010 20:37:37 GMT

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.