Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
stabben23
Partner - Master
Partner - Master

Stockvalues in different levels

Hi,

I have a stockbalanse for every day. I want to show this on a week and month level in a pivot.

when I use week as dimension I want to show the last days value in that week and if I use month I want to show last day in month value.

Load * Inline [ Date, stockvalue 20140617 11775520 20140618 11578401 20140619 11340838 20140620 11340838 20140621 11340838 20140622 11340838 ];

4 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Try with this

FirstSortedValue(stockvalue, -Date)

stabben23
Partner - Master
Partner - Master
Author

Like this but with value 11 340 838 for week 25

pivotRB.png

stabben23
Partner - Master
Partner - Master
Author

I think I need to explain that I dont have the total stockvalue on every day, I have to do a sum over all items.

tresesco
MVP
MVP

If you could post a qvw with sample data and explain expected output against that data, would be much easier for us and faster (to get answer) for you.