QlikView Pivot Chart not showing columns more than 39

[venkat_thota]

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.

[Anil_Babu_Samineni]

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

[venkat_thota]

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

[Anil_Babu_Samineni]

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

[venkat_thota]

Anil,

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

[Brett_Bleess · Accepted solution]

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

[venkat_thota]

Hi Brett,

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