topic Re: Issue on calculating Quantity per Month in QlikView

Issue on calculating Quantity per Month

c1bs — Fri, 28 Apr 2023 09:17:24 GMT

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!

Re: Issue on calculating Quantity per Month

PrashantSangle — Fri, 28 Apr 2023 09:35:24 GMT

Create month Year field in back end ( Script)

then use in expression as

Sum( Total<MonthYear> Qty)

Regards,

Prashant Sangle

Re: Issue on calculating Quantity per Month

Prem0212 — Fri, 28 Apr 2023 10:07:29 GMT

First create Month Year column and then use this expression.

I hope this works for u.

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

Re: Issue on calculating Quantity per Month

c1bs — Tue, 02 May 2023 02:11:29 GMT

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

Re: Issue on calculating Quantity per Month

c1bs — Tue, 02 May 2023 02:13:42 GMT

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

Re: Issue on calculating Quantity per Month

Prem0212 — Tue, 02 May 2023 06:24:51 GMT

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