Issue on calculating Quantity per Month

[c1bs]

Hi forum,

I have a problem with my visualizations on QlikView. I want to calculate Quantity per Month (Total Qty) based on the value from the Quantity itself and grouping it per Month Year.  

Currently, the table is like below (sample):

I want the desired outcome to be like below (sample):

I want to achieve the Total Qty using an expression.

Some notes:
1. Month Year (from the Date) and Total Qty are the expressions.

2. Total Qty is a total of Quantity by Month Year.

3.  Somehow, I can't solve this by Editing the Script, I can only work this by using expressions.

4. Please assume that all fields have other values also, not like the sample above.

Thank you and hopefully I get feedback very soon from the forum.

Cheers!

[PrashantSangle]

Create month Year field in back end ( Script)

then use in expression as

Sum( Total<MonthYear> Qty)

Regards,

Prashant Sangle

[Prem0212]

First create Month Year column  and then use this expression.

I hope this works for u.

Aggr(Sum(Quantity), name of month year column)

[c1bs]

Hi @PrashantSangle 

Is it possible to solve this problem without back end?
Somehow, I have a limitation (can't access back end) and only working it by using an expression.

If it's possible, let me know your suggested solution.

Thank you for replying to me!

Regards,

Kevin

[c1bs]

Hi @Prem0212 

How exactly to create the column of Month Year? Is it by using back end script?

If that so, I have a limitation right now and I can't access the back end.

If it's possible to work this problem with using expression, let me know your suggested solution.

Thank you for your time!

Regards,

Kevin

[Prem0212]

You can use the following  expression in the table visual and its working for me

Use this expression   Month("Ship Date")&'-'&Year("Ship Date")   instead of month year column in the table below

Please like and Accept the solution