topic Re: month in QlikView

month

Wed, 25 Nov 2020 16:16:04 GMT

I have field called month_order (FY:Apr to Mar) now I need to use in set analysis

In text object, max(month_order ) here am getting 12

I want to show Max Month Dec

I have tried with monthname(month_order) and test(month_order) but not working.

any ideas pls suggest!

m_woolf — Thu, 04 May 2017 12:00:08 GMT

You can define your month_order field in script using dual to give the field both a numeric and string value.

Shouldn't you want max(month_order) to show Mar?

Thu, 04 May 2017 12:19:40 GMT

With dual I have given already like dual('Apr',1)...............................................................('Mar',12)

In text object am using max(month_order) it returns 12 only

I want to show max month as Mar

how do I use in set analysis??

Frank_Hartmann — Thu, 04 May 2017 12:43:31 GMT

attached sample might be helpful

Thu, 04 May 2017 13:05:47 GMT

That is fine but how do we use in set analysis???

If I use in text object max(month) its giving me 12

I nee to to show employee count max month.

Frank_Hartmann — Thu, 04 May 2017 13:09:48 GMT

in textbox try like:

=only(aggr(max(Month),SortOrder))

hope this helps

tresB — Thu, 04 May 2017 13:16:45 GMT

If you need 'Dec' instead of 12, try like:

=Month(MakeDate(1, max(month_order )))