Qlik Sense Pivot Table Help: Determine a Field value based on another max(Field)
I have a pivot table made using the following information.
What I am able to do in Qlik Sense is create the pivot and find the min date for each Vehicle_No. (Note: I used Excel to make this example of what I'm attempting to do).
Question: How do I display the Battery Voltage in the box where the min date currently is, instead of the date?
I am trying to find the battery voltage, per truck, per the latest date. I thought AGGR was the right path
I have listed out the various Measures I've attempted (denoted by // at the start of the line). The bottom attempt appeared to work, however my real set has five vehicles & two returned values and three returned '-'.
Any help would be greatly appreciated. It is worth noting that I may be missing something basic with syntax. I have been using tutorial videos, these forums, and the help.qlik site for guidance. However, I haven't managed to resolve this item.