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: 
Anonymous
Not applicable

Repetitive values in pivot table

Hi,

I have a pivot table where certain expressions have to used as dimensions and only monthly counts have to be displayed as expressions. The dimension values are repeating. can someone please help me fix this? thanks!

16 Replies
avinashelite

from the dimension suppress null values ...i could see the values are repeating because you have null values in the dimension

Anonymous
Not applicable
Author

I did suppress the null values and it didn't help

Anonymous
Not applicable
Author

Hi Prashant,

I'm trying to display same values in both straight table and pivot table.

But as you see in below screenshots, pivot table is jus displaying the totals in each row. \

Please see the sample.qvw attached to my original post.

I would really appreciate your help on this.

PrashantSangle

If possible share your file...

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

‌please find my qvw attached to the original post all the way on the top. Thanks!

PrashantSangle

missing attachment.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
kamalqlik
Partner - Specialist
Partner - Specialist

Please attach the QVW file so that we can have a look into it.