topic Re: Sum quantity in QlikView

Sum quantity

patrou38 — Fri, 06 Jul 2018 08:45:55 GMT

Hello,

I have a table in which there are a quantity of equipment by week (February weeks in my example).

in another table I would like to have the sum of qty by month. I don't find the expression, the aggr ????

I expect that I'm enough clear.

than you for your help.

Patrick

Re: Sum quantity

dapostolopoylos — Fri, 06 Jul 2018 08:50:51 GMT

If there is a Month filed in the Data Model all you have to do is to bring it in your chart instead of Year-Week field...

If you don't have a Month field i suggest you to create it...

Re: Sum quantity

patrou38 — Fri, 06 Jul 2018 09:12:24 GMT

Hello, I tried without success as you can see below

Re: Sum quantity

dapostolopoylos — Fri, 06 Jul 2018 10:33:25 GMT

You must have done something wrong with your date fields...

Can you share your script or at least the part where you create your date fields?

Re: Sum quantity

patrou38 — Fri, 06 Jul 2018 11:37:54 GMT

ciao Dimitrios,

below my script.

thank you very much for your help.

I had in mind that the problem coming from my script

Re: Sum quantity

dapostolopoylos — Fri, 06 Jul 2018 11:44:20 GMT

What i want you to show me is how you create the Calendar fields and most of all the Work_Week field which is your key

Re: Sum quantity

patrou38 — Fri, 06 Jul 2018 11:51:03 GMT

ok.

the calendar is defined in an excel file like this:

Re: Sum quantity

dapostolopoylos — Fri, 06 Jul 2018 12:06:20 GMT

Your calendar seems to be allright...

Did you use the Sum() function when yoyu tried to replace Year_Week with Year_Month in your chart?

Re: Sum quantity

patrou38 — Fri, 06 Jul 2018 12:10:54 GMT

I'm using the same expression for the both .. .either for week or for month ....

Re: Sum quantity

sunny_talwar — Fri, 06 Jul 2018 12:49:25 GMT

Would you be able to share your Excel file by attaching it here

Uploading a Sample

Re: Sum quantity

patrou38 — Fri, 06 Jul 2018 12:59:48 GMT

Enclosed my excel file used as calendar.

thank you again for your precious help.

Patrick

Re: Sum quantity

sunny_talwar — Fri, 06 Jul 2018 13:09:17 GMT

Oh... I see that you are doing a Distinct count... I am not sure why you need a DISTINCT... but if you need that... may be try this

Sum({<Facility = {'$(vFacility)'}, ModelFamily = {'$(vModelFamily)'}>} Aggr(Sum(DISTINCT {<Facility = {'$(vFacility)'}, ModelFamily = {'$(vModelFamily)'}>} [TC inventory]), Year_Week, Year_month))

Re: Sum quantity

patrou38 — Fri, 06 Jul 2018 13:14:40 GMT

guys,

I want to thank you very very much for your prompt and precious help... it's really appreciate.

have a good rest of the day

best regards,

Patrick