topic Re: If conditions in QlikView

If conditions

Mon, 18 May 2015 12:00:44 GMT

Hai to All,

I am Rachamreddy, Now start to learn Qlikview i have lot of confusion about If conditions because i am very new stranger of this course please give me suggestions and some examples If conditions

Thanking You

Re: If conditions

Gysbert_Wassenaar — Mon, 18 May 2015 12:41:33 GMT

Have you read the entries in the Qlikview help file? Open Qlikview Desktop and open the help file from the Help menu: Help -> Content. Then click the Index tab and enter 'if' as keyword. You'll find two entries: one for 'if' and one for 'if ..then..elseif..else..end if'. Read them both. If you still have questions after reading those help file entries feel free to ask for clarification of anything you don't understand yet.

Re: If conditions

robert_mika — Mon, 18 May 2015 13:29:33 GMT

The basic IF testament taken 3 arguments:

logical_condition,value returned if the logical condition is true,value returned if the logical condition is false

To example:

=IF(1=1,'True','False')

In your Qlikview Application you may have situation when you got field "Sales":

Sales

You can write IF condition saying that

IF(Sales>2,"Yes","No")

The result of the statement if used let say in Straight table would be new fields with values

Yes

Those are very basic examples but I hope it will give you some insight.

As Gysbert mentioned look into Qlikview help or just Google IF statement.

The principle of this function are the same with almost every software.