Solved: need to show the latest sales data for each id - Qlik Community

Report Inappropriate Content · ‎2012-10-21

for the above data, i need to show the id and latest sales of the id , ie.i should get the below result

Could anyone help me ..

Thanks,

Sankar

swuehl · ‎2012-10-21

In your table chart with dimension id, try using this expression

=FirstSortedValue( sales, -Date)

with sales and Date being your field names for above columns.

Hope this helps,

Stefan

swuehl · ‎2012-10-21

In your table chart with dimension id, try using this expression

=FirstSortedValue( sales, -Date)

with sales and Date being your field names for above columns.

Hope this helps,

Stefan

MayilVahanan · ‎2012-10-21

Hi

Try like this

Firstsortedvalue(sales,-date,1)

Hope it hels

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

jeffmartins · ‎2012-10-21

Hi sankar_thia,

If you are trying to do it in the script you can use max function and an inner join to get the latest sales.

See the attached file, hope it helps you.

Regards

Report Inappropriate Content · ‎2012-10-22

i got the result using 'FirstSortedValue( sales, -Date)'.

thanks all for your help