# New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for
Did you mean:
Creator II

## Stocke value report

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.

S.

1 Solution

Accepted Solutions
MVP

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......

8 Replies
Not applicable

may be februry total stock count is 255

and end of march stock count is 100

Not applicable

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

total stock sold each month

total stock returned easch month

etc

Specialist III

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

MVP

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)

Specialist III

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

MVP

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......

Creator II

Hi Maxgro,

your solution is good for me.

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

Creator II

Hi Muguel,

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

Thank again