topic Re: first sorted value and aggr? in QlikView https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435450#M431281 <HTML><HEAD></HEAD><BODY><P>If I open it to dag (Day) I would like to see the beginstock of that day.</P><P>When I opt to Maand (Month) I would like to see the beginstock of the first of that month.</P><P>For Jaar (Year) the same.</P><P>And If I only till the 3th column I would like to see the first beginstock of the selected period (in the above selection)</P><P></P><P>Hope it is all clear.</P></BODY></HTML> Mon, 13 Nov 2017 15:13:45 GMT kris_vliegen 2017-11-13T15:13:45Z first sorted value and aggr? https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435446#M431277 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have in the data a field by day with the begin-stock of that day.</P><P>Now I would like to see this beginstock in a pivot table.</P><P></P><P>If I select only the station, Product and type I should see the first beginstock.</P><P>If I select year I would like to see the beginstock of that year.</P><P>Ther are also month and day dimensions</P><P>can I do this with first sorted value and/or aggr?</P><P></P><P><IMG alt="rendementJPG.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182524_rendementJPG.JPG" style="height: auto;" /></P><P>regards,</P><P>Kris</P></BODY></HTML> Wed, 08 Nov 2017 12:57:17 GMT https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435446#M431277 kris_vliegen 2017-11-08T12:57:17Z Re: first sorted value and aggr? https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435447#M431278 <HTML><HEAD></HEAD><BODY><P>I believe you should be able to do this... but I am not sure if we can provide you with an exact expression based on the information you have provided. Would you be able to share a sample?</P></BODY></HTML> Wed, 08 Nov 2017 14:32:14 GMT https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435447#M431278 sunny_talwar 2017-11-08T14:32:14Z Re: first sorted value and aggr? https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435448#M431279 <HTML><HEAD></HEAD><BODY><P>I've inserted the dashboard.</P><P></P><P>Regards,</P><P>Kris</P></BODY></HTML> Mon, 13 Nov 2017 15:06:00 GMT https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435448#M431279 kris_vliegen 2017-11-13T15:06:00Z Re: first sorted value and aggr? https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435449#M431280 <HTML><HEAD></HEAD><BODY><P>Just to clarify, when you say select "<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">station, Product and type"... do you mean expand the dimensions? Also, Beginstock seems to only have 0 value... even when I expand it to all the way to day field... what number do you expect when I open only untill jaar? What do you expect when i open Maand? and etc?</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/183067_Capture.PNG" style="height: 224px; width: 620px;" /></SPAN></P></BODY></HTML> Mon, 13 Nov 2017 15:10:47 GMT https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435449#M431280 sunny_talwar 2017-11-13T15:10:47Z Re: first sorted value and aggr? https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435450#M431281 <HTML><HEAD></HEAD><BODY><P>If I open it to dag (Day) I would like to see the beginstock of that day.</P><P>When I opt to Maand (Month) I would like to see the beginstock of the first of that month.</P><P>For Jaar (Year) the same.</P><P>And If I only till the 3th column I would like to see the first beginstock of the selected period (in the above selection)</P><P></P><P>Hope it is all clear.</P></BODY></HTML> Mon, 13 Nov 2017 15:13:45 GMT https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435450#M431281 kris_vliegen 2017-11-13T15:13:45Z Re: first sorted value and aggr? https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435451#M431282 <HTML><HEAD></HEAD><BODY><P>It is sort of clear, but why do I only see 0's when I open till date? Is the expression incorrect, or do you expect to see 0s?</P></BODY></HTML> Mon, 13 Nov 2017 15:17:01 GMT https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435451#M431282 sunny_talwar 2017-11-13T15:17:01Z Re: first sorted value and aggr? https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435452#M431283 <HTML><HEAD></HEAD><BODY><P>The expression is incorrect. I was trying some things but didin't get the solution.</P></BODY></HTML> Mon, 13 Nov 2017 15:25:29 GMT https://community.qlik.com/t5/QlikView/first-sorted-value-and-aggr/m-p/1435452#M431283 kris_vliegen 2017-11-13T15:25:29Z