Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
Akina0929
Creator
Creator

how to get latest value from every group ?

I have product code ,product name

             001,pen

            002,pen

          003,pen

         004,paper

         005,paper

expected output should be follows

product code,product name

003,pen

005,paper

 

thanks

4 Replies
sunny_talwar

Is this something you want in the script or front end? For front end, try this

Dimension

product name

Expression

Max([product code])
Raghul
Former Employee
Former Employee

One way of doing is to use Mapping and ApplyMap () function in Data load script using a Flag as shown below.

Community1.JPG

 

Then add the dimension (Object) and Measure (If(Flag = 1, Value, NULL)). And exclude the NULL values.

Community2.JPG

Note: This is sample method, you can also try different options.

 

Akina0929
Creator
Creator
Author

only one value getting for all products

sunny_talwar

Which approach did you try?