topic Re: Multiple Values on Data Points in QlikView

Multiple Values on Data Points

Tue, 02 Jun 2015 15:19:24 GMT

I'm trying to display an expression value on data points (not the value of the bar, but another calc) in my bar chart, so the bar shows the total sale amount by month, and the value at the top of the bar shows the average order total. There are 2 bars - one showing total gross sales and one showing total net sale amount, and i want the average of each to appear on top of each bar. But I can only get one to show, and it always shows above the 2nd bar. Is there a way to get both expression values to show?

See attached example

Re: Multiple Values on Data Points

sunny_talwar — Tue, 02 Jun 2015 15:33:39 GMT

Is this what you are looking for?

If yes then use these two expression (remove the two additional for just labels)

Exp1: =Dual(Num(Sum(GrossSales)/Sum([Sales Qty]), '#.00'), Sum(GrossSales))

Exp2: =Dual(Num(Sum(Sales)/Sum([Sales Qty]), '#.00'), Sum(Sales))

Re: Multiple Values on Data Points

pokassov — Tue, 02 Jun 2015 15:45:30 GMT

Hello, Ashley!

See attach.

Re: Multiple Values on Data Points

Mon, 08 Jun 2015 16:11:21 GMT

Yes, this did it. Thank you!

Re: Multiple Values on Data Points

sunny_talwar — Mon, 08 Jun 2015 16:14:28 GMT

Awesome

I am glad it worked.

Best,

Sunny