topic Three valuas in set analysis in QlikView

Three valuas in set analysis

Wed, 23 Mar 2011 19:29:28 GMT

Hi ,

I would appreciate help with the following. I have a set analysis expression where i use a period and then where a tarricode must filter on 3 values for tarricode. I have tried the following but it is not working

Sum({$<Period={$(=Max(Period)-1)},TariffCode={'58081'},TariffCode={'58071'},TariffCode={'H081'}>}(AmountExcl ))

In normal sql statement it would be where tarrifcode in ('value1','value2','value3') - how does one put this into a set analysis ?

Thank so much.

Louw

Three valuas in set analysis

Miguel_Angel_Baeyens — Wed, 23 Mar 2011 19:42:59 GMT

Hello Louw,

You are almost there:

Sum({< Period = {$(=Max(Period)-1)}, TariffCode={'58081', '58071', 'H081'} >} AmountExcl)

Hope that helps.

Three valuas in set analysis

Sun, 27 Mar 2011 10:09:21 GMT

and this worked for me. Thanks so much.

Regards

Louw