Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Three valuas in set analysis

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

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hello Louw,

You are almost there:

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


Hope that helps.

View solution in original post

2 Replies
Miguel_Angel_Baeyens

Hello Louw,

You are almost there:

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


Hope that helps.

Not applicable
Author

and this worked for me. Thanks so much.

Regards

Louw