topic Re: Help with idea in QlikView

Help with idea

Anonymous — Mon, 11 Mar 2013 14:41:08 GMT

Hello,

Please help with idea. I have an expression

Count({<[Variable]= {'A','4'}>}[Variable])/

Count({<[Variable]= {'A','B','2','3','4'}>}[Variable])

Variable has 6 tags A,B,C,2,3,4.

Do you know how don't include C in TOTAL?

Thanks,

Anonymous — Mon, 11 Mar 2013 14:49:35 GMT

I have 10 like this variable.

How to simplify

If(Variable='C','', Variable) as Variable

If(Variable1='C','', Variable1) as Variable1

If(Variable2='C','', Variable2) as Variable2

If(Variable3='C','', Variable3) as Variable3 and etc.

Thanks,

sushil353 — Mon, 11 Mar 2013 14:52:50 GMT

Try this:

Count({<[Variable]= {'A','4'}>}[Variable])/

Count({<[Variable]-= {'C'}>}[Variable])

HTH

Sushil

jagan — Mon, 11 Mar 2013 14:55:51 GMT

Hi,

The below expression excludes C in the set analysis expression.

=Count({<[Variable] -= {'C'}>}[Variable])

Qlikview will show error near -=, but it works.

Hope this is what you are expecting.

Regards,

Jagan.