topic Pivot table issue in QlikView

Pivot table issue

kishorj1982 — Fri, 28 Jul 2017 06:19:51 GMT

Hi all,

PFA.

Whenever selection is 1year we need to sjow last 12 months data and >1 year summation in 1 chart.

Is this possible in pivot table.I have pivoted my second dimension as per to meet the requirement but question is how to get >1 year data in 1 chart.

Currently I am using 2 different charts but second chart is breaking in accesspoint and looks like unprofessional.

Please suggest.

Re: Pivot table issue

avinashelite — Fri, 28 Jul 2017 06:57:25 GMT

Did not get your complete requirement , you want the >1 year data also in the same chart ? could share what is the out put your excepting

Re: Pivot table issue

kishorj1982 — Fri, 28 Jul 2017 06:59:28 GMT

Yes, in same chart and output should be same

Thanks

Re: Pivot table issue

avinashelite — Fri, 28 Jul 2017 07:05:56 GMT

Your already getting that in the chart rite ? what is the issue ? could share the sample output your looking for

Re: Pivot table issue

kishorj1982 — Fri, 28 Jul 2017 07:10:39 GMT

I am using 2 charts.It is breaking on accesspoint show need to show all in one chart.I have used different chart for >1 year.

Thanks

Re: Pivot table issue

avinashelite — Fri, 28 Jul 2017 07:24:43 GMT

See application may break to multiple reason , do to un associated columns , data model etc . here I am not able to understand what exactly happening in your case ....because you have shared only the sample and its not the complete model I guess

Re: Pivot table issue

kishorj1982 — Fri, 28 Jul 2017 07:46:31 GMT

Hi Avinash,

PFA.

On aceespoint it looks like below.It seems awakward. So I need to get the result in 1 chart.

Thanks