Discussion board where members can get started with Qlik Sense.
I have a list of products, A - X that are sold at various prices. My table consists of records of each sale:
Product Location Amount
A OK 4.56
A LA 12.45
B KS 5.00
B MI 3.75
... and so on.
I have a pareto chart drawn, but I want a Text Box that says (for example):
Product A, $25 total spend
I am able to get Product A using:
But I don't know how to pull the summarized value for the top product. In other words, I can generate the Top Product = Product A, but I can't generate the $25 Total Spend part of the summary.
Go to Solution.
Try Below in your expression
I see what you did there, but it didn't work. I got - for the whole thing, although no syntax errors
i did tried with my data it worked .. just check the labels
Ok, we were missing a closing parenthesis ) after the last [Amount]. Don't know why it didn't flag that as a syntax error, but once that was fixed it worked fine. Thank you!
Glad . It worked.. !
Please close the thread by marking the Correct Answers