Help with idea

[Anonymous]

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]

Or

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]

Try this:

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

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

HTH

Sushil

[jagan]

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.