Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
chinnukool
Contributor III
Contributor III

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

chinnukool
Contributor III
Contributor III
Author

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

chinnukool
Contributor III
Contributor III
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.
chinnukool
Contributor III
Contributor III
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.
kamalqlik
Partner
Partner

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