topic QlikView Pivot Chart not showing columns more than 39 in QlikView

QlikView Pivot Chart not showing columns more than 39

venkat_thota — Sat, 16 Nov 2024 02:01:24 GMT

Hi,

I have a pivot chart, has yearwk in dimensions and sales, cusotmer count...etc. in expressions.

my pivot chart grows horizontally for every week. Pivot is showing good till week 39. From Week 40, its showing blank.

This is only when I change to WebView or after published on Server and view the report in browser.

Please suggest any solution for this.

Re: QlikView Pivot Chart not showing columns more than 39

Anil_Babu_Samineni — Wed, 06 Nov 2019 10:55:36 GMT

Try to use Descending Order for Week and see If data arrives?

Re: QlikView Pivot Chart not showing columns more than 39

venkat_thota — Wed, 06 Nov 2019 10:58:26 GMT

Its already sorted Anil in Ascending order. Thats the requirement to show the weekly total for a year.

Re: QlikView Pivot Chart not showing columns more than 39

Anil_Babu_Samineni — Wed, 06 Nov 2019 11:02:56 GMT

I would like to know the descending order way. Once you enabled kindly check the data for >= 39 weeks is coming?

Re: QlikView Pivot Chart not showing columns more than 39

venkat_thota — Wed, 06 Nov 2019 12:06:15 GMT

Anil,

No luck after changing to Descending order. week order changed but now the first 15 weeks are not showing.

Re: QlikView Pivot Chart not showing columns more than 39

Brett_Bleess — Tue, 12 Nov 2019 13:53:10 GMT

Venkat, I suspect this is working as expected per the following Article reference, but I see the article may need an update to include Pivot table, will likely rephrase things to all 'table' objects in Ajax client/WebView mode...

Ajax Client/WebView column limitation

Regards,
Brett

Re: QlikView Pivot Chart not showing columns more than 39

venkat_thota — Tue, 12 Nov 2019 14:04:16 GMT

Hi Brett,

thanks for clarifying this. I am working on workaround. thanks.