topic Re: Stocke value report in QlikView

Stocke value report

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I need to produce the report in attachment,

but I don't understand hot to do it.

I've problem dealing Initial Stock and final stock values.

Help please.

Thank in advance

Re: Stocke value report

Mon, 03 Oct 2016 11:13:15 GMT

may be februry total stock count is 255

and end of march stock count is 100

Re: Stocke value report

Mon, 03 Oct 2016 11:17:01 GMT

you can find how many stock sold and returned each month.

total stock sold each month

total stock returned easch month

etc

Re: Stocke value report

miguelbraga — Mon, 03 Oct 2016 11:30:49 GMT

Hey there,

Maybe this:

Initial Stock:

Sum({<Month = {'$(=max(Month)-1)'}>} InitialStock)

Final Stock:

Sum({<Month = {'$(=max(Month))'}>} FinalStock)

See the attached file

Best regards,

D.A. MB

Re: Stocke value report

maxgro — Mon, 03 Oct 2016 11:38:04 GMT

with your data you can make a chart with store as dimension, a listbox for Month field and these expressions

sum({$ <Month={$(=min(Month))}>} InitialStock)

sum({$ <Month={$(=max(Month))}>} FinalStock)

or, for a static chart

sum({$ <Month={2}>} InitialStock)

sum({$ <Month={3}>} FinalStock)

Re: Stocke value report

miguelbraga — Mon, 03 Oct 2016 11:48:03 GMT

Your first expression will not work because you will get wrong values if you test it as it is, see the result:

Also a static formula isn't, in my personal opinion, a good option in a Dashboard.

Best regards,

D.A. MB

Re: Stocke value report

maxgro — Mon, 03 Oct 2016 11:55:44 GMT

I suggest to add a listbox to select the month field; when you select Month 2 and 3 you get the initial for month 2 and final for month 3

Regarding a static formula, yes, I agree usually isn't a good option but maybe is wthat Steve wants

Also min or max Month could be a wrong option if there are many years......

Re: Stocke value report

Anonymous — Mon, 03 Oct 2016 21:18:51 GMT

Hi Maxgro,

your solution is good for me.

Just one thing: having more years, what I have to use instead min or max ?

Re: Stocke value report

Anonymous — Mon, 03 Oct 2016 21:20:11 GMT

Hi Muguel,

thanks for your help. Your solution has been useful for me.

Thank again