Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Last Value Monthwise

Hi,

I need last rate of items from its rate field monthly and yearly itemwise.

I have year , Month, Items, Rate,Date fields. So , How can i get itemwise value monthly and yearly.

i tried

firstsortedvalue(Rate,-Date)

But it gave me some worng picture.

Similarly , I tried

Lastvalue(Rate). This also gave me Worng Picture. Anybody Please help.

1 Reply

Re: Last Value Monthwise

You can use

firstsortedvalue(DISTINCT Rate,-Date)

Community Browser