topic Re: Month Year in QlikView

Month Year

sudhir0538 — Wed, 17 Jul 2019 04:15:29 GMT

Hi Experts !

In my db month field is maintained in numeric form i.e 1,2,3,--12. and year field is also numeric like 2018,2019 and so on.

I want to display month year as a dimension in a bar chart. Any Ideas of how to achieve this field inside QV.

Thanks.

Re: Month Year

mostwanted123 — Wed, 17 Jul 2019 04:20:16 GMT

Hi Sudhir,

Please find below code -

Month(MonthField) &'-'& YearField as Year-Month

Thanks

Re: Month Year

sudhir0538 — Wed, 17 Jul 2019 04:32:30 GMT

Hi @mostwanted123

Thanks for the reply but it's not working. Its combined and Only 3 months are displaying.

Re: Month Year

mostwanted123 — Wed, 17 Jul 2019 04:40:36 GMT

Can you share the screenshots of the code written by you and output ?

Thanks

Re: Month Year

sudhir0538 — Wed, 17 Jul 2019 04:48:33 GMT

Hi Please find the attached.

Re: Month Year

sudhir0538 — Wed, 17 Jul 2019 04:49:13 GMT

Re: Month Year

MindaugasBacius — Wed, 17 Jul 2019 05:09:24 GMT

You need to create Master Calendar or else you will get not consistent Year-Month dimension.

Use simply Year & Month as [Year Month]

Re: Month Year

jonathandienst — Wed, 17 Jul 2019 05:35:56 GMT

...
Date(MakeDate(YearField, MonthField), 'yyyy-MM') as Date,
Month(MakeDate(YearField, MonthField)) as Month,
YearField as Year,
...

Re: Month Year

sudhir0538 — Thu, 18 Jul 2019 04:32:05 GMT

Hi iJonty,

Thanks for sharing the work around. It really works. Here in the dimension i want to show the months in descending format for only last 12 months. like today is month of July 2019 so data will be of July 2018 to July 2019. July 18/2018 August 2018 Sep 2018 and after dec 2018 jan 2019 should appear but not july 2019.

Can you help me achieve this. screenshot attached

Re: Month Year

jonathandienst — Thu, 18 Jul 2019 05:09:43 GMT

You are asking a new question now. I suggest that you mark this thread as answered (if you original question was answered) and open a new posting with the question. You can link back to this post if necessary.

I did not really understand what you were looking for in the new question and the screenshot did not help much. In the new post, please explain in more detail what you need and include a sample qvw (or a focussed screenshot) that illustrates the question more clearly.

Re: Month Year

sudhir0538 — Thu, 18 Jul 2019 06:03:16 GMT

Okay..

Please find the link for new post.

https://community.qlik.com/t5/QlikView-Scripting/Display-last-12-months-data-in-Bar-Chart-using-dimension-not/m-p/1603465#M95932