Discussion Board for collaboration on QlikView Scripting.
I have a code in my script like this that somebody has written previously:
If(Sales> '0' or [Sales Flag] = 'Y', 'Y', 'N') as WarrantFlag
What is this code mean?
Is it like this? if sales is greater than zero or Sales flag = Y then Y otherwise N.
If i want to us these piece of code in where clause after the load statement then how should i write the code?
Solved! Go to Solution.
the code mens
[sales flag]= 'yes' the value of sales is more than " 0" or sales flag value is "yes" it will returns " yes" otherwise "No" by that it will create a flag.
hope this helps u
Thanks for the reply.
How can i use this code in where clause in the load script?
Where-----------(how to use the code here?)
Your are correct exists function is used to check if the value exists for previous loaded values, Is that what you want or while loading you want to check the condition then what I suggested would be fine.