topic Set Analysis in If expression in QlikView

Set Analysis in If expression

Fri, 09 May 2014 21:10:57 GMT

Hi guys,

I have this expression

count(distinct {$<id = P({1<bonus={"*"}>})>} id)

and i want to use it in a dimension like this

If (count(distinct {$<id = E({1<bonus={"*"}>})>} id) <> 0, Number)

But it does not work and gives error "Error in calculated dimension".

What I want to do is....if count is not equal to 0 then only show a particular "Number " on the dimension...

Any help would be appreciated.

Regards,

Saurabh

mambi — Fri, 09 May 2014 21:15:20 GMT

Why you don't just use : if (count( {1} distinct bonus)>0, Number)

Fri, 09 May 2014 21:16:56 GMT

Hello,

may you attach application with sample data?

regards

Darek

Fri, 09 May 2014 21:22:25 GMT

It still gives same error

swuehl — Fri, 09 May 2014 23:44:58 GMT

Try

=aggr( If (count(distinct {$<id = E({1<bonus={"*"}>})>} id) <> 0, Number), Number)