Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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