topic Re: Moving annual bar chart in QlikView

Moving annual bar chart

ale_nilo84 — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I am trying to build a moving annual bar chart, but so far i can just display only the 4 months of the year 2016 and not the last 12 months . How can i do it to display the last 12 months?

Thanks in advance

Re: Moving annual bar chart

Anonymous — Tue, 07 Jun 2016 06:30:07 GMT

I realized this by using variables and a calculated dimension

=if ((RepDate>=vStartDate) and (RepDate<=vEndDate),date(RepDate,'MM/YY'))

I have a master calender, the user selects the start month

Start and end variable will be set depending of selected date

Re: Moving annual bar chart

ale_nilo84 — Tue, 07 Jun 2016 19:10:20 GMT

I Could do what was suggested to do. But in the last column it shows a invalid value . What do you think it could have happened?, please help me

Re: Moving annual bar chart

sunny_talwar — Tue, 07 Jun 2016 19:42:49 GMT

Try suppressing the null dimension by checking 'Suppress When Value Is Null' for your dimension on the dimension tab.

Re: Moving annual bar chart

ale_nilo84 — Tue, 07 Jun 2016 20:43:23 GMT

Problem solved, thanks!!

Re: Moving annual bar chart

sunny_talwar — Tue, 07 Jun 2016 21:01:22 GMT

Please mark Rudolf's response as the correct answer as I merely helped you get the final bit corrected. If you want you can mark my response as helpful, but truly it's Rudolf who deserves the points for correct response.

Thank you and regards,

Sunny

Re: Moving annual bar chart

Anonymous — Wed, 08 Jun 2016 06:11:44 GMT

goto Dimension tab and seect your dimension

then mark "suppress when value is null"

goto tab presentation and mark "suppress zero values"

that should suppress the last bar marked with "-"