Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat_thota
Contributor III
Contributor III

QlikView Pivot Chart not showing columns more than 39

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.

Labels (2)
1 Solution

Accepted Solutions
Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

6 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
venkat_thota
Contributor III
Contributor III
Author

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
venkat_thota
Contributor III
Contributor III
Author

Anil,

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

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

venkat_thota
Contributor III
Contributor III
Author

Hi Brett,

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