i am working on a piece of code in which I want to select the highest value. Max() should by all means work however I pulling the data in from another table in which it holds several of the data types I am looking for.
Eg. I am looking for MD, and there are 3 MD characteristics in the spreadsheet so using sum will give me 301. 301 is the highest value so I want to show that but using max() gives me 180, one of the vales for MD. Using max(sum()) is obviously garbage.
Can anyone help me on this, is there a way of using an if statement to recognise that 301 is the highest value?
My code to get the 301 is sum{<SPREADSHEET.Data={"MD"}>} BILL_SQ)
-Im pulling data from a table (SQI). to get this data im using a spreadsheet- so the line spreadsheet.data="MD" is looking for things on the SQI by filtering through the spreadsheet. Pulling the data, which is categorised as MD.
-On qlikview, I have a table that tells you all the months and what the MD is for each month. i'm trying to create a column in which I have the max MD, so users can select this instead of filtering through the report looking for the highest.
-On the sqi table there are several MD characteristics, thus why I'm using sum(). When I use max, it selects the highest MD, but not the highest sum of MD.
