Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mborsadw
Partner - Creator
Partner - Creator

Showing Min of a measure in the first row of a pivot table

Is there a way to show the Min of a measure in the first row of a pivot table in Qlik Sense?

clipboard_image_0.png

OnHand is the difference between Supply and Demand. The OnHand values for A and B for 1-Jan are 2 and 7 respectively. The minimum of that is 2 and needs to be displayed at the top in a separate row. Similarly the Min(OnHand) for 2-Jan is the min of -5 and -9.

Labels (1)
3 Replies
Rohan
Specialist
Specialist

Hey, Is this the result you wanted ? I have attached the images of my load script & the Pivot table output.

I have used Customer & flag as dimensions for row & Date as Dimension for Column. You have to keep Totals label on in the Customer field.  Take min(qty) as a measure in the Pivot table.Pivot.jpgPivot_Script.jpgpivot-output.jpg

 

Let me know if this works or if you have any queries regarding this.

Thanks & Regards.

mborsadw
Partner - Creator
Partner - Creator
Author

Thanks for taking the time to respond Rohan. Are you showing the Min of OnHand values in the top row OR the min of all quantities in that column? If its Min of OnHand what expression did you add and where?

Rohan
Specialist
Specialist

Hello,

I have just put Min of all quantity as Measure. The value in the top row represents the minimum of all quantities & is aggregated Date-wise, So the row will show the minimum on-hand value date-wise. As On-hand value will be the minimum of the three quantity values, in "almost" every scenario.

Let me know if you still have any queries. 

Thanks & regards.