Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
lionking15
Creator
Creator

Dynamic label

HI

i have created Dynamic label for current month i.e current month-$(=max({<FiscalYear={$(=max(FiscalYear))}>}FiscalMonth))

but it is showing current month as number means 1 for jan,2 for feb .but i want month as jan, feb form how to do this????

Thanks

2 Replies
its_anandrjs
Champion III
Champion III

When you use Max function it converts the output into the NUM better if you use the Num field to check this values

Regards

Anand

avinashelite

Agreed with , Anand . Try to enclose this with month() function in order to convert it to Jan format