Discussion board where members can get started with QlikView.
Try like this in script
Pick(monthnum, 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec') AS Month
Date# is how Qlikview knows what "1" or "2" means... Then use the "Month" function around it. No hard coding years needed.
Month(Date#([FIELD],'M')) as MONTH
if script like below
load * inline [
then simply write the expression like below
if(Mon=2,'Feb')) up to 12 months
I have used the above script but I am not getting the Month names in order like jan, feb, mar...i am getting in alphabetical order like apr, aug, dec, feb....
Can you please suggest me how can I get that in this order. jan, feb, mar...
I should not add inline table
Thanks in Advance
You need to create dual values. The simplest way is to use
but you can also modify Pratyush' script to