Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Graph and Sum quantites per month

Hi,

I have a little problem.

I have datas like that :

ItemDateQuantity
A01/03/20162
B01/03/20161
A01/03/20165
C05/03/20163
A10/03/20164

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.

8 Replies
Kushal_Chawda

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)

or

Dimension: Month(Date),Item

Expression : Sum(Quantity)

avinashelite

Try like this

1.Add Month & Item as the dimensions and 

2.add sum(quantity) as expression

this shoudl  give you the result

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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 !

jagan
Luminary Alumni
Luminary Alumni

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.

Chanty4u
MVP
MVP

chk dis

Chanty4u
MVP
MVP

sry

ahmar811
Creator III
Creator III

hi

Beaulieu Mathieu

try attached sample file.hope this help you

Capture.PNG

Thanks & Regards

Ahmar Ansari