Sanity check with If and aggr

Thu, 03 Jan 2013 13:45:36 GMT

Hi!

I'm doing a sanity check so that an office only is connected to one region. To do this in a straight table is no problem. CLEARINGNUMMER as dimension and an expression aggr(count(DISTINCT Region), CLEARINGNUMMER) .

But now I would like to have a happy smiley when the data is ok and a sad when it's not. So to check this I use an If-statement. The problem is that I have to select all CLEARINGNUMMER for it to work. Is there a way of adding the dimension in the If-statement?

='qmem://<builtin>/Smiley'&

if(aggr(count( DISTINCT Region), CLEARINGNUMMER

)=1,1,3)&'_Y.png'

Rgds

thomas

Re: Sanity check with If and aggr

danielrozental — Thu, 03 Jan 2013 13:51:47 GMT

Try something like

='qmem://<builtin>/Smiley'&

if(sum(aggr(if(count( DISTINCT Region)>1,1), CLEARINGNUMMER

))=0,1,3)&'_Y.png'

topic Re: Sanity check with If and aggr in QlikView

Sanity check with If and aggr

Re: Sanity check with If and aggr