Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show textual name and minimum value in a pivot table cell

Let's have a hypothetical widget purchasing company... they buy widgets in different shapes and colors

per shape and color we would like to show the top 3 purchases ranked by the lowest price per shape.

Example output I would like to produce...

ovalroundsquare
blue1

john

125

jack

350

pete

235

2

jack

140

john

352

claudia

243

3

claudia

150

pete

356

john

255

red1

etc.

2
3

Any help on how to fix this would be great... thanks....

1 Reply
Not applicable
Author

Can you please share some sample data for your requirement?