topic Re: if statement in qlikview expressions in QlikView

if statement in qlikview expressions

Wed, 04 Jun 2014 20:03:26 GMT

Hi there,

I am creating an analysis dashboard. Since the currency rate does not include 1 for US Dollars, I need to write an If statement for the sales in US$ across the stores around the world. Since store ID 1,16, 19 are all using US dollars, the expression I wrote is :

If (StoreID=1 or 16 or 19, sum(sale), sum(sale/rate)). But when I double check, say Japanese store, the result returned to me is still sum(sale) instead of sum(sale/rate). Can someone tell me what goes wrong here?

Thank you so much!

Best Regards,

Gloria

Re: if statement in qlikview expressions

venkatg6759 — Wed, 04 Jun 2014 20:14:42 GMT

if(sum({$<StoreID={'1','16','19'}>}sale),sum(sale),sum(sale/rate))

Re: if statement in qlikview expressions

swuehl — Wed, 04 Jun 2014 20:22:01 GMT

Your condition is always true.

Try

If (StoreID=1 or StoreID = 16 or StoreID =19, sum(sale), sum(sale/rate))

If (match(StoreID,1,16,19), sum(sale), sum(sale/rate))

Re: if statement in qlikview expressions

shawn-qv — Fri, 06 Jun 2014 00:29:35 GMT

Or you could convert the Sale values in your script instead, and just do a sum(Sale) in your chart expression.

If doing it in script, either one of swuehl's expression will work and you would just alias it as Sale.

Re: if statement in qlikview expressions

jagan — Fri, 06 Jun 2014 01:56:08 GMT

Hi,

Converting in script itself is a good idea, because if you are doing this in expression then you have to write if in all the set analysis expression.

Try like this in script

LOAD

If(Match(StoreID, 1, 16, 19), sale, sale/rate) AS SalesValue

FROM Datasource;

Now in set analysis just use

Sum(SalesValue)

If you don't want to handle this in script then use this expression

If (Match(StoreID, 1, 16, 19), sum(sale), sum(sale/rate))

Sum({<StoreID*={1, 16, 19}>}sale) + Sum({<StoreID-={1, 16, 19}>}sale/rate)

Hope this helps you.

Regards,

Jagan.