If formula doesnt work as intendet

Wed, 29 Aug 2012 07:47:17 GMT

Hello again,

a little question:

if([Kl. kupca cjenik]<>'1' and PriceGroup <>'A',[Rabat A T1],

if([Kl. kupca cjenik]<>'2' and PriceGroup <>'A',[Rabat A T2],

if([Kl. kupca cjenik]<>'3' and PriceGroup <>'A',[Rabat A T3],

if([Kl. kupca cjenik]<>'1' and PriceGroup <>'D',[Rabat D/G T1],

if([Kl. kupca cjenik]<>'2' and PriceGroup <>'D',[Rabat D/G T2],

if([Kl. kupca cjenik]<>'3' and PriceGroup <>'D',[Rabat D/G T3],

if([Kl. kupca cjenik]<>'1' and PriceGroup <>'G',[Rabat D/G T1],

if([Kl. kupca cjenik]<>'2' and PriceGroup <>'G',[Rabat D/G T2],

if([Kl. kupca cjenik]<>'3' and PriceGroup <>'G',[Rabat D/G T3],

if([Kl. kupca cjenik]<>'1' and PriceGroup <>'M',[Rabat M T1],

if([Kl. kupca cjenik]<>'2' and PriceGroup <>'M',[Rabat M T2],

if([Kl. kupca cjenik]<>'3' and PriceGroup <>'M',[Rabat M T3],

if([Kl. kupca cjenik]<>'4' and PriceGroup <>'T',[Trade 4],

if([Kl. kupca cjenik]<>'5' and PriceGroup <>'T',[Trade 5],

if([Kl. kupca cjenik]<>'6' and PriceGroup <>'T',[Trade 6],

if([Kl. kupca cjenik]<>'7' and PriceGroup <>'T',[Trade 7],

if([Kl. kupca cjenik]<>'8' and PriceGroup <>'T',[Trade 8],

)))))))))))))))))

This is my Expression in a chart. The formula should do:

- Check Kl kupca Cjenik value and PriceGroup Value

- When OK then show value "Rabat xx"

- else check next...

now in my source table(Kl. kupca and PriceGroup) i did select these values: 8 and T, but the chart expression gives me the value of the first one(1 and A)

Anybody an idea what i did wrong in my expression?

Thank you,

kristian

Re: If formula doesnt work as intendet

Wed, 29 Aug 2012 07:51:11 GMT

<> means 'not equal to'. Because you have selected 8 (= not equal to 1) and T (= not equal to A) the first if-then-else evaluates to 'true', so [Rabat A T1] will be returned.

Change all <>'s to ='s and it should work as you intend to.

Re: If formula doesnt work as intendet

Wed, 29 Aug 2012 08:29:53 GMT

What a stupid thing i did... thank you!

topic Re: If formula doesnt work as intendet in QlikView

If formula doesnt work as intendet

Re: If formula doesnt work as intendet

Re: If formula doesnt work as intendet