Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
rohitians
Creator III
Creator III
‎2013-06-25 08:03 AM

Straight Table..sorting

Hello,

I have a straight table where i have three dimensions Product Group, Pack Size,UOM...

and sales comparison is der...

product group may have product of different pack size....

The problem comes for sorting i am able to sort it at product group level but if a certain pack size has less sales it also appears in top 20 as the overall product group sales is high i want to sort the table according to purely sales...

I am attaching excel file for an idea...

Thanks and Regards,

Rohit

Preview file
12 KB
570 Views
0 Likes
3 Replies
Not applicable
‎2013-06-25 08:12 AM

select sort by expression and provide sales expression.

426 Views
0 Likes
rohitians
Creator III
Creator III
‎2013-06-25 08:17 AM
Author

In response to

Hello,

I did that ....

Go through the excel file..

Thanks,

Rohit

426 Views
0 Likes
Not applicable
‎2013-06-25 08:25 AM

Hi

Ur Product Group "I' is gaving 2 PackSize.so it is comming like..

shorting 1.bmp

Pls do one thing in ur straight table go Properties > Sort > uncheck all columns sorting..just check 2013-14 column

shorting.bmp

Hope it will help u

regards-Bika

426 Views