Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
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.

Help please.

Thank in advance

S.

1 Solution

Accepted Solutions
Highlighted
MVP
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......

View solution in original post

8 Replies
Highlighted
Not applicable

may be februry total stock count is 255

and end of march stock count is 100

Highlighted
Not applicable

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

total stock sold each month

total stock returned easch month

etc

Highlighted
Specialist III
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

Highlighted
MVP
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)


Highlighted
Specialist III
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

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

View solution in original post

Highlighted
Creator II
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 ?

Highlighted
Creator II
Creator II

Hi Muguel,

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

Thank again