This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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