topic Re: How to create a Bar chart with Month and Year in QlikView

How to create a Bar chart with Month and Year

FabioP — Sat, 16 Nov 2024 02:59:30 GMT

Dear all,

I'd like to create a bar chart with the first bars contain the year value and other bars with the month value only of the last year, but the data are in the different columns! And the year value is not necessarily the sum or avg of months, is a specific value. Follow the table.

Is it possible?

Re: How to create a Bar chart with Month and Year

FabioP — Wed, 17 Jul 2019 13:39:13 GMT

This is the format of bar chart what I need:

Re: How to create a Bar chart with Month and Year

Brett_Bleess — Thu, 08 Aug 2019 20:49:59 GMT

Best I have to try to find some ideas is the Design Blog area:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Use the search dialog there to search all the posts, hopefully you can find something that will help you, I am not really sure what you need here given I do not do a lot of development.

If you have an app going, you may want to attach what you have, as that normally makes it much easier for folks to try to help you get what you need.

Regards,
Brett

Re: How to create a Bar chart with Month and Year

lockematthewp — Fri, 09 Aug 2019 15:43:12 GMT

I would make two separate bar charts. the first would have year as the dimension and yearvalue as the expression. the second would have the dimension as =if (year = year(today()), month) and the expression would be monthvalue.