Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Former Employee
Former Employee

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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Former Employee
Former Employee

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.
venkat_thota
Contributor III
Contributor III
Author

Hi Brett,

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