topic Re: Show Last Period Value in QlikView

Show Last Period Value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a problem about showing last period value in pivot table.

Here is my data:

I have two different district. And maximum week Of District 001 is 1605, on the other side maximum week of district 002 is 1606.

So i want to create a pivot table like this :

District 002 shown right value (7), but district 001 return zero value (0).

I'm using this expression on my "Last Week Value" column : =sum({<Week={$(=max(Week))}>}Value)

The result i expect is

Can anyone give me the solution ? I also attached my sample QVW file.

Thanks in advance.

Anil_Babu_Samineni — Wed, 10 May 2017 02:20:30 GMT

But, For 002 you are expecting 7 or 5 ??

Anonymous — Wed, 10 May 2017 02:33:36 GMT

Hi,

For 002 i expect 7, because i want to show value on week 1606 (last week of district 002)

Thanks

Anil_Babu_Samineni — Wed, 10 May 2017 02:49:21 GMT

Oh, Sorry i have not read properly. May be this?

FirstSortedValue(Value, Aggr(Week, Value))

Anonymous — Wed, 10 May 2017 04:11:10 GMT

Hi,

I have try your solution,

It works on my sample data.

But it is not working on my real data, unfortunately i can't share my data, because it's confidential.

Do you have another solution ?

Thanks in advance

Anil_Babu_Samineni — Wed, 10 May 2017 05:27:44 GMT

Atleast data need to reply. Would it possible sample data. Or

You may explain bit more