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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
arulsettu
Master III
Master III

month in num to string

Hi,

i am having month filed like this

month

0

1

2

3

4

5

6

7

8

9

10

11

12

i want to convert this in jan,feb,mar......

so used this Month(MakeDate('2014',monthfield)) as newmonth

its working i used this newmonth field to convert quarter but it is not deriving the quarter. also i used this newmonth filed in chart its not giving the result. if i use old month field its giving desired result

any suggestions plz?

23 Replies
arulsettu
Master III
Master III
Author

Hi Treseco,

              Plz check this chart in sample app

tresesco
MVP
MVP

Try expression like:

sum({<ACNT_FLEX_02={'Balance Sheet'},TBAL_Month={'>=$(vTBL_month)'}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)

arulsettu
Master III
Master III
Author

hi Tresesco,

                  i will try and let you know and vTBL_month is variable it contain max(TBAL_Month) is it ok and i need to show last six month value alos

thank you

arulsettu
Master III
Master III
Author

HI tresesco,

                      Its Working but problem in Quarter. i can only get Q1 and Q4. sorry for the delay

Thank you