Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
0li5a3a
Creator III
Creator III

top 50 products by volume

Hi Guys,

I need to show top 50 products by volume in a Straight Table  and the totals at the bottom for these top 50.

The first 2 columns suppose to be dimension and all the rest expressions.

Please find the attached files.

I want to  thank you in advance!

Best Regards,

3 Replies
antoniotiman
Master III
Master III

Hi Constantin,

see Attachment.

Regards,

Antonio

saimahasan
Partner - Creator III
Partner - Creator III

Hi

See the below attachment.. Top 10 as per voucher(as an eg.)

effinty2112
Master
Master

Hi Constantin,

                         Something like this? I've removed most of the lines to save space.

Product sum([No of Units]*[Sale Price])
69598.53
a13600
a2208
a3134.91

Set Dimension Limits like this:

DimLim.JPG

If you want the totals at the bottom not the top change the setting in the Presentation tab.

Cheers

Andrew