If conditions

[#1]

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

[Gysbert_Wassenaar]

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.

[robert_mika]

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

1

2

3

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

No

No

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.