topic Re: How to work with multiple if statements in QlikView

mutliple if

Tue, 22 Sep 2015 20:15:39 GMT

Hi All,

I am trying to work in QV scripting by applying multiple If Conditions.

maxgro — Tue, 22 Sep 2015 20:27:02 GMT

first, start simple with 2 or 3 conditions and if works add some other conditions

second I don't think you need "and if" but something like that with, at the end, a number of ) as the number of conditions

if(condition1, value1,

if(condition2, value2,

if(condition3, value3,

value4

))) as field,

if you post the doc we can better check the syntax

robert_mika — Tue, 22 Sep 2015 20:36:51 GMT

I am trying to work in QV scripting by applying multiple If Conditions.

But my brackets are not working properly

Really? Where?:)

How long did it take to write this statement?

Congratulation for the effort anyway...

As Massimo suggested you something else than IF..

Anonymous — Tue, 22 Sep 2015 20:40:23 GMT

amazing, how do you want to control that Statement?

as I noticed there are a lot of duplicates

just one idea:

why not provide an inline table with all combinations
I donot know your datamodel, so how to connect to toher tables?

TEST:

load * Inline [

[WS_Category], [Claim_Activity], [Claim Process], [RequestType], OUTPUT

Russia, Scrap,,, [QV_Cash_Out]+[Replacement Costs]

Turkey,,,,,,[QV_Cash_Out]

Sermicro,,,,QV_Cash_Out]+ 350,

RTS,,TCA,CC,,[Tariff to be paid to claimer(EUR)]+[Replacement Costs]