Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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.

3 Replies
Highlighted
Creator
Creator

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.

Highlighted
Partner
Partner

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?

Highlighted
Creator
Creator

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.