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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

top 3 values and corresponding attributes

ProductSourceDestinationCostCost 2Total Cost
HandbagAA10

5

5
Handbag2BB1101020
Handbag3CC1201535
Handbag4DD1301040
Handbag5EE1402060

Right now, I'm using the above example where I'm using =FirstSortedValue(Source, [Total Cost],1)

Is there any way that if my data had 0 as one of the cost, not to include it as the cheapest source?

For example, the cheapest source would be B, C, and D.

10 Replies
Not applicable
Author

Thanks for your help!!