topic Re: value with last date in QlikView

value with last date

Wed, 17 Jul 2013 07:26:10 GMT

hello community,

I want to figure out the the up-to-date value, so the the value with the last date and put it in a pivot table.

So I have an article with a few dates and a different price behind it.

I want to have the price from the article with the last date. I know it sounds pretty simple but i can't do it.

Please let me know which date format I have to use

thanks

er_mohit — Wed, 17 Jul 2013 07:38:51 GMT

hii you can do this by using firstsortedvalue concept

see the attached file

Wed, 17 Jul 2013 07:46:20 GMT

try this

Dimension--Date

Expression---

Sum({$<Date={"=$(=Max(Date))"}} Price)

or try this

try this

Dimension--Date

Expression---

Sum({$<Date={"<=$(=Max(Date))"}} Price)

Wed, 17 Jul 2013 07:53:13 GMT

I want as dimension jus the articles and as formula the updatet price.

I tried the first sortet value concept and with a few exceptions it works.

the formula Sum({$<Date={"=$(=Max(Date))"}} Price) doesn't work in my case sorry

Wed, 17 Jul 2013 07:56:59 GMT

Can I also do a total sum of

FirstSortedValue([MCHEAD-1.KOCSU1],-[MCHEAD-1.KOPCDT])