Discussion board where members can get started with QlikView.
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
Hear 1-Month is January and 12-Month is December
I want same results in qlikview
You can try below script.
Load Num(Month([Received Date]))&'-Month' as Month
View solution in original post
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
Miguel del Valle
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