topic Re: chart with Quarter year filed in QlikView

chart with Quarter year filed

prma7799 — Thu, 29 Oct 2015 06:43:09 GMT

Hi All,

I have one requirement that i need quateryear field(Q1 15 Q2 15 Q3 15.....ETC ) in chart for all years and the this year sale with growth line...

Can you please help me out.

PFA

Thanks

Re: chart with Quarter year filed

avinashelite — Thu, 29 Oct 2015 07:30:40 GMT

you have already implemented Quarter Year rite?

If your looking for the Liner growth line ? then you can check the Liner option in the expression

Re: chart with Quarter year filed

prma7799 — Thu, 29 Oct 2015 07:49:47 GMT

Yes..

But when i applied pivot table expression in bar chart the values is not coming proper.

Please can you help me to achieve this .

PFA...

Re: chart with Quarter year filed

prma7799 — Thu, 29 Oct 2015 09:11:56 GMT

Hi All, gwassenaar‌, sunindia‌ jagan‌,

Any help on this?

Re: chart with Quarter year filed

avinashelite — Thu, 29 Oct 2015 09:35:20 GMT

Problem is with the Growth calculation , what is the requirement here ? a easy fix would be check of the current year condition in the dimension itself that would help

Re: chart with Quarter year filed

prma7799 — Thu, 29 Oct 2015 09:54:03 GMT

Hi Avinash,

The growth formula is right as you see the pivot table am taking that only.

I want chart like below...

See the red and blue mark I and my team achieve the two axis but didn't get growth bar like below...

Thanks

Re: chart with Quarter year filed

avinashelite — Thu, 29 Oct 2015 10:12:29 GMT

yes, I got your point the problem is your trying to get the chart data for the current year and the growth rate is calculated over the time that's why it not getting populated properly , once i get time will try to tweak your expression

Re: chart with Quarter year filed

prma7799 — Thu, 29 Oct 2015 10:16:47 GMT

Hi Avinash,

For time-being give some alternate solution because it is urgent requirement for our client.

All we are stuck with this....

And please if you get free time then please look into this.

Thanks in Advance.

Re: chart with Quarter year filed

avinashelite — Thu, 29 Oct 2015 11:20:34 GMT

Hi ,

I got the problem

In the pivot table your not considering the year hence its calculating the values based on the quarter , if you convert the bar chart with only Quarter values it will surely work fine . if you need to include the year than , you need to calculate the rolling month values in the script level and then you need make use the same in front end. Check this article

Calculating rolling n-period totals, averages or other aggregations

Re: chart with Quarter year filed

prma7799 — Thu, 29 Oct 2015 11:37:12 GMT

Yes...

You are right but our requirement is to show at least three year data with all quarter like below

If i am taking only quarter then it will show me only two for 2015-16 and four for 2014-15

Re: chart with Quarter year filed

prma7799 — Fri, 30 Oct 2015 04:37:15 GMT

Hi Avinash,

Can you look into this...

Thanks