Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hai to All,
Thanking You
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.
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.