Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I TRYING TO CONVERT EXCEL SCRIPT TO QLIKVIEW SCRIPT.
MY EXCEL SCRIPT IS: MONTH([@[Receive Date]] & "-Month"
In Excel Getting Results like this: 1-Month
2-Month
3-Month .
....12-Month
Hear 1-Month is January and 12-Month is December
I want same results in qlikview
Hi,
You can try below script.
Load Num(Month([Received Date]))&'-Month' as Month
From Xyz;
Regards,
Kaushik Solanki
Hi,
You can try below script.
Load Num(Month([Received Date]))&'-Month' as Month
From Xyz;
Regards,
Kaushik Solanki
Hi Gireesh,
Correct expression in QV:
Month([Receive Date])&' -Month'
But if you want to see month name you need to use:
monthname([Receive Date]) as %Month
Regards
Miguel del Valle
thanks
thanks
getting one problem on this expression
I don't have January data but this expression showing garbage data like "-Month"
how to ignore this one