topic Re: if statement - set analysis in QlikView

if statement - set analysis

Wed, 05 Jun 2013 10:32:57 GMT

hi i am trying to achieve the following

I have three companies

000 - Sweden

001 - Norway

003 - UK

when calculating KPI incoming orders i have the following statement

Sum(if(Bol_ID = 003,OrderRad.NettoBelopp*#Dat_O*OH.Kurs_FSG_act/2,OrderRad.NettoBelopp*#Dat_O))

This is correct, when running for individual companies, but when i try to put together 000 and 003 i get the wrong values,

is it possible to rewrite the statement whereby you always include 003 condition instead of having an if statement?

Best,

Bradley

er_mohit — Wed, 05 Jun 2013 10:40:28 GMT

Sum(if(wildmatch(Bol_ID,'001','003'),OrderRad.NettoBelopp*#Dat_O*OH.Kurs_FSG_act/2,OrderRad.NettoBelopp*#Dat_O))

Sokkorn — Wed, 05 Jun 2013 10:45:52 GMT

Hi Bradley,

Not sure you try this yet:

1. In set analysis

Sum({$<Bol_ID = {'000','003'}>} OrderRad.NettoBelopp*#Dat_O*OH.Kurs_FSG_act/2)

2. Use IF()

Sum(

If(Match(Bol_ID,'000','003'),OrderRad.NettoBelopp*#Dat_O*OH.Kurs_FSG_act/2,

OrderRad.NettoBelopp*#Dat_O

)

Regards,

Sokkorn