topic bar chart , returning sum(sales) and reference ID in QlikView

bar chart , returning sum(sales) and reference ID

thanhphongle — Mon, 18 Jan 2016 11:38:13 GMT

Hello Community,

I'm not really good at set analysis, but it would be great if anyone can help me out here.

I have a table with

Date	Reference ID	Product	Sales
01.01.15	100001	A	100
01.01.15	100001	A	100
01.01.15	100002	B	200
01.06.15	100003	C	300
01.06.15	100003	A	100
01.09.15	100004	B	200
01.09.15	100004	C	300

The barchart should return me sum(sales) with the reference ID as Quick Information and Values in the graphic by choosing Date as Dimension

Example:

01.01.15 = sum(sales) = 200 with Reference ID 100001

01.01.15 = sum(sales) = 200 with Reference ID 100002

01.06.15 = sum(sales) = 400 with Reference ID 100003

01.09.15 = sum(sales) = 300 with Reference ID 100004

Re: bar chart , returning sum(sales) and reference ID

tresB — Mon, 18 Jan 2016 11:53:42 GMT

Do you want two bars for 01.01.15 date?

Re: bar chart , returning sum(sales) and reference ID

miguelbraga — Mon, 18 Jan 2016 12:01:50 GMT

Greetings,

Check this out:

Hope it helps

Regards,

Re: bar chart , returning sum(sales) and reference ID

miguelbraga — Mon, 18 Jan 2016 12:04:15 GMT

By the logic of your example:

Example:

01.01.15 = sum(sales) = 200 with Reference ID 100001

01.01.15 = sum(sales) = 200 with Reference ID 100002

01.06.15 = sum(sales) = 400 with Reference ID 100003

01.09.15 = sum(sales) = 300 with Reference ID 100004

Shouldn't the last expression result be 500?

Re: bar chart , returning sum(sales) and reference ID

sunny_talwar — Mon, 18 Jan 2016 12:05:48 GMT

Looking for this?

Dimension:

=Dual(Date, Date&[Reference ID])

Expression1:

=Sum(Sales)

Expression2:

=[Reference ID]

Expression2 needs following settings on the expression tab

Re: bar chart , returning sum(sales) and reference ID

HirisH_V7 — Mon, 18 Jan 2016 12:17:19 GMT

Hi ,

May be like this,

Dimension:

Date

Reference ID

Expression:

=Aggr(Sum(Sales),[Reference ID],Date)

Hope this helps,

HirisH

Re: bar chart , returning sum(sales) and reference ID

miguelbraga — Mon, 18 Jan 2016 12:26:57 GMT

Missed the part where you want a bar chart, just convert using the screenshots provided:

Re: bar chart , returning sum(sales) and reference ID

thanhphongle — Mon, 18 Jan 2016 12:46:15 GMT

Thank you to everyone responding on my problem.

It works well with the solution of Hirish and Miguel!