Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
geogou1973
Creator
Creator

Modify Data in a a chart

Hello,

I have the following data

Valid DateItemSupplierCost Price
23/12/20191392178549632,41
01/02/20211392178549631,69
13/07/20211392178549631,69

 

and i want to create a chart that in one line have the following image

ItemSupplierValid DateCost PriceValid DateCost Price
13921785496323/12/20192,4113/07/20211,69

 

How can i manage this. I want to have the item in the specific supplier in one line , and the max date of changing the cost price with the date and the price and the date with the price of the max date before of this date.

I have the 13/07/2021 that is the max date that the cost price has changed and i want also to have the max date before of this date and price that the price is different from the max date that is 23/12/2019.

Thank you in advanced.

1 Reply
chrismarlow
Specialist II
Specialist II

Hi,

Try Min, Max and FisrtSortedValue, something like;

20210927_1.png

Cheers,

Chris.