topic Re: If statement?!? in QlikView

If statement?!?

Fri, 30 Jan 2015 14:37:17 GMT

I've my data like following

I need help with the statement.

In my report I want to present the following.

If category = 30 then present Value as 150 000

If category is <>30 then present Value as 0

If value has a number then present that number times 1000 (x1000). This last one shall overrule the previous statements.

I'm not sure if it's best to do it in the loadscript and load it into colum "newValue" or if I should to it in the expression.

MarcoWedel — Fri, 30 Jan 2015 15:44:13 GMT

Alt(Value*1000, -150000*(Category=30))

Anonymous — Fri, 30 Jan 2015 16:26:48 GMT

Hi,

You'd better calculate a field NewValue in the script.

Use the following script:

If(Isnull(Value)=-1,

If(Category=30, 150000,0),

1000*Value) as NewValue

Otherwise if you want to use it in a graph directly, just use the following as the expression with Value and Category as dimension:

If(Isnull(Value)=-1,

If(Category=30, 150000,0),

1000*Value)

Mon, 02 Feb 2015 09:41:39 GMT

I solved it by using

=If(Value>0, sum(Value*1000),(If(Category=30, 150000, 0)))