This content has been marked as final.
Show 5 replies

Re: Set Analysis? Find Formula Value for Dimension Value
Sunny Talwar Feb 21, 2018 12:36 PM (in response to Qlik Sapiens)Try this
='The Dim1 value with the highest value in sum(Expression1) is: ' & FirstSortedValue(Dim1, aggr(sum(Expression1), Dim1)) // here I want to see "C", not the formula value.

Re: Set Analysis? Find Formula Value for Dimension Value
kakani saikishore Feb 22, 2018 2:01 AM (in response to Sunny Talwar )Hi Sunny .... what exactly Aggr() dose here could you explain this expression

Re: Set Analysis? Find Formula Value for Dimension Value
Fawaz Abdul Azeez Feb 22, 2018 2:16 AM (in response to kakani saikishore)aggr is creating a virtual table with 2 columns dim1 and its sum. FirstSortedValue will get the max(beacuse of negative sign) in DIM1 from that table

Re: Set Analysis? Find Formula Value for Dimension Value
kakani saikishore Feb 22, 2018 2:55 AM (in response to Fawaz Abdul Azeez)Thank you Fawaz for the clarification.




Re: Set Analysis? Find Formula Value for Dimension Value
Qlik Sapiens Feb 22, 2018 1:49 AM (in response to Qlik Sapiens)Thank you very much, that did the job!
 QS