Skip to main content
Announcements
Join us on Feb.12 to Discover what’s possible with embedded analytics: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
satish25
Creator
Creator

Test for Pivot and Straight Table

Hello Everyone,

I have to find the Top 5 Customers for Every Month in a straight table in Qlik Sense.
When I create a Pivot table, all the Values show correctly.
However, When I convert it into a straight Table, it Sums the values of all the Months and shows the combined top 5 Customers.
I want to show the Value Appearing in the Pivot Table in the Straight Table Respectively.

i.e. 

Suppose I select 3 months i.e. Dec, Jan, Feb the pivot table and straight table differ
I want the same values to appear in the straight table as they are appearing in the pivot table

I have Attached sample data for better understanding.

Thanks

Labels (3)
0 Replies