topic Re: Graph and Sum quantites per month in QlikView

Graph and Sum quantites per month

Mon, 21 Mar 2016 06:59:35 GMT

Hi,

I have a little problem.

I have datas like that :

Item	Date	Quantity
A	01/03/2016	2
B	01/03/2016	1
A	01/03/2016	5
C	05/03/2016	3
A	10/03/2016	4

In my graph I want to show the quantites per month.

I have a master calendar.

And, for example, in my graph I want theses values (for March month) :

A = 11

B = 1

C = 3

I can't explain why, but I can't do that...

In dimension I have "Month" field.

In Expression I have : =Quantity

I tried : Sum(Quantity) but with that I get the total sum and I just want the sum per month.

Could you help me?

Thanx for helping me.

Re: Graph and Sum quantites per month

Kushal_Chawda — Mon, 21 Mar 2016 07:03:40 GMT

Make sure that Your calendar is linked on Date field and Date Field is in proper date format. Then what you are doing is should work.

Dimension - Month, Item

Expression- Sum(Quantity)

Dimension: Month(Date),Item

Expression : Sum(Quantity)

Re: Graph and Sum quantites per month

avinashelite — Mon, 21 Mar 2016 07:14:03 GMT

Try like this

1.Add Month & Item as the dimensions and

2.add sum(quantity) as expression

this shoudl give you the result

Re: Graph and Sum quantites per month

Gysbert_Wassenaar — Mon, 21 Mar 2016 07:15:44 GMT

Use Month and Item as dimensions and sum(Quantity) as expression.

Re: Graph and Sum quantites per month

Mon, 21 Mar 2016 07:16:07 GMT

Hi,

The approach is correct, however the something is going wrong with Date field.

It might be where you have segregated the Month from the date field or association of the Fields in your Data Model.

Hope it helps.

Cheers !

Re: Graph and Sum quantites per month

jagan — Mon, 21 Mar 2016 07:16:14 GMT

Hi,

Derive a month in script like below

Data:

LOAD

MonthName(DateFieldName) AS Month

FROM DataSource;

Now try like below in chart:

Dimension: Month, Item

Expression: Sum(Quantity)

Hope this helps you.

Regards,
Jagan.

Re: Graph and Sum quantites per month

Chanty4u — Mon, 21 Mar 2016 07:18:39 GMT

chk dis

Re: Graph and Sum quantites per month

Chanty4u — Mon, 21 Mar 2016 07:19:15 GMT

sry

Re: Graph and Sum quantites per month

ahmar811 — Mon, 21 Mar 2016 07:20:01 GMT

Beaulieu Mathieu

try attached sample file.hope this help you

Thanks & Regards

Ahmar Ansari