Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Know maximum item

Dear grus!!

my question is so simple but i m not able to solve it.....

I have created line graph with item_name as dimension and sum(purshase cost) as expression

I have sort this graph decending.

so i am getting one of the item in top (let say computer)

now i want to show/highlight the name of that item (computer) which has highest cost in text box.

what would be the expresion in text box.?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hm,

One way of doing it, which might be overkill is:

=maxstring(aggr(dual(item_name, sum(PurchaseCost)), item_name))

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Hm,

One way of doing it, which might be overkill is:

=maxstring(aggr(dual(item_name, sum(PurchaseCost)), item_name))

Not applicable
Author

=maxstring({<PurchaseCost={$(=max(PurchaseCost))}>}Item_name)

Regards

Raj

Not applicable
Author

thnks for answer its work perfectly fine..... u rocks

Not applicable
Author

@arjuun

u also right but it is giving me item having highest purchasing cost did not apply on sum(prucshasing_cost)..

well thans to u also