Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
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?