Solved: Know maximum item - Qlik Community

Report Inappropriate Content · ‎2012-09-25

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.?

Anonymous · ‎2012-09-25

Hm,

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

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

Anonymous · ‎2012-09-25

Hm,

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

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

Report Inappropriate Content · ‎2012-09-25

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

Regards

Raj

Report Inappropriate Content · ‎2012-09-26

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

Report Inappropriate Content · ‎2012-09-26

@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