Discussion board where members can learn more about Qlik Sense App Development and Usage.
Though a lot of reading I've gotten my KPI box to work...yay! However, I am wondering how to make the related label dynamic?
Example, I know that the Max QTY is 10, but in the KPI I want to show the label related to that KPI (i.e. Jan) in addition to the QTY.
How can I make that work? Sorry if it's a basic question - I'm really struggling on this one. I stole this table from another thread, but I don't want the quantity - I want the month.
A simplified example of my code. I want the "CATEGORY" field related to the Maximum field value.
you can achieve using FirstSortedValue function.
you can modify according to your example
View solution in original post
Thank you Raj,
This works for my question.
Then I had to amend the code to get the smallest value as well (second request from user). Removing the minus sign in front of AGGR to gives that. I had to use the RANK function to eliminate the nulls, but it works. Thank you Raj!