Discussion Board for collaboration on QlikView Scripting.
LOAD * INLINE [
num(Dual(F1, Match(F1, 'Jan', 'Feb', 'Mar'))) as F3 // what does this expression mean..
DROP Table A;
It returns the number portion of the selected "F1".
using NUM( over DUAL( is unnecessary and meaningless
We use DUAL() to assign numeric value to a text
but by using NUM( over Dual( we are only retaining the number returned by Match(), it should just be
Match(F1, 'Jan', 'Feb', 'Mar'))) as F3
Match() returns the position of the value found,
example if F1 was Jan it would return 1, if Mar then 3...
You might as well try with
hope this helps
Hi John, Vineeth, and Marco,
I got all the points from all of you three. But I want to confirm that...Is it giving any concept of UNSELECTED VALUE FETCHING..??