Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
satish25
Contributor III
Contributor III

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 (4)
0 Replies