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?
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.
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?
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.