Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shivani_singhal
Partner - Contributor III
Partner - Contributor III

num(Dual(F1, Match(F1, 'Jan', 'Feb', 'Mar'))) as F3 ??

A:

LOAD * INLINE [

    F1, F2

    Jan, 10000

    Feb, 20000

    Mar, 30000

];

NoConcatenate

B:

Load F2,

  F1,

  num(Dual(F1, Match(F1, 'Jan', 'Feb', 'Mar'))) as F3  // what does this expression mean..

  Resident A;

  DROP Table A;

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

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...

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

4 Replies
jrepucci15
Creator
Creator

It returns the number portion of the selected "F1".

vinieme12
Champion III
Champion III

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...

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
MarcoWedel

You might as well try with

Month(Date#(F1,'MMM'))

hope this helps

regards

Marco

shivani_singhal
Partner - Contributor III
Partner - Contributor III
Author

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..??

Regards,

Shivani Singhal