topic Re: Chart with additional data in QlikView

Chart with additional data

robert_mika — Thu, 12 Jun 2014 16:54:28 GMT

I have a bar chart showing numbers let say per sales

Is it possible to add numbers of Sales men in the bracket.

So the numbers will be looking like this

20(3)

25(4)

30(5)

Re: Chart with additional data

Thu, 12 Jun 2014 17:01:41 GMT

Hi Robert,

In general yes let me imagine your table structure like this:

Sales Man | Sales | Number

Jhon | 30 | 3

Mary | 25 | 4

Xavier| 20 | 5

You can try Sales Man as Dimension and this expression: =Sum(Sales) & '(' & Number & ')'

Best Regards.

Re: Chart with additional data

robert_mika — Fri, 13 Jun 2014 11:26:18 GMT

Thanks but this does not work.

As it will take the second calculation and merge with first one and the result is a blank chart.

I think I need a text wrapper for the sum of the second calcaulation but I can not find an appropiate fuction.

Re: Chart with additional data

Jason_Michaelides — Fri, 13 Jun 2014 11:29:11 GMT

You need an aggregation function around both parts:

=Sum(Sales) & '(' & Sum(Number) & ')'

Re: Chart with additional data

Fri, 13 Jun 2014 11:44:49 GMT

Add a new expression and uncheck bar and only show data points

Re: Chart with additional data

robert_mika — Fri, 13 Jun 2014 13:55:41 GMT

Still does not work.

Coudl you provide an exaple?

Re: Chart with additional data

robert_mika — Fri, 13 Jun 2014 13:57:08 GMT

In this situatio whe let say the Sales will let say 50,000 ad only 1 sales men the data will be not visible.

Re: Chart with additional data

Jason_Michaelides — Fri, 13 Jun 2014 14:35:13 GMT

I'm an idiot and Thomas is right. I see what you mean about the wild difference in values though. I suggest you use Dual() to give the Salesmen sum the same value as the Sales sum, but present using the Salesmen sum:

Bars expression = Sum(Sales)

Bars2 (only data points) expression = Dual('(' & Sum(Number) & ')',Sum(Sales))

See if that works...

Jason

Re: Chart with additional data

Anonymous — Fri, 13 Jun 2014 14:37:21 GMT

Hi,

This thing can be achieved through the dual function

dual(Sum(Sales) & '(' & Sum(Number) & ')')

Sum(Sales))

Re: Chart with additional data

MarcoWedel — Mon, 16 Jun 2014 20:48:50 GMT

Hi Robert,

the already proposed dual function could work like:

=Dual(Sum(Number)&' ('&Count(DISTINCT [Sales Man])&')', Sum(Number))

hope this helps also

regards

Marco

Re: Chart with additional data

robert_mika — Fri, 27 Jun 2014 07:44:56 GMT

Thnak you Marco

Re: Chart with additional data

MarcoWedel — Fri, 27 Jun 2014 08:05:57 GMT

You're welcome

Regards

Marco