Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
silambarasan130
Not applicable

Replacing values in the next record..??

Hi All,

I have table below mentioned.

    

DATEBRANDPRODUCTRATE
6/1/2016ABCSMPO5000
6/1/2016DTCAPLE4300
6/1/2016VGSCART2000
6/1/2016CTGBEGTS7000
6/1/2016OTSNTB9000
6/2/2016ABCLPS3000
6/2/2016DTCORG7500
6/2/2016VGSONIN3000
6/2/2016CTGSHTS9500
6/2/2016OTSPEN1500
6/3/2016ABCSMPO3500
6/3/2016VGSTNTA5500
6/3/2016DTCSTANE4500
6/3/2016OTSNTB7000
6/4/2016ABCHRDH6500
6/4/2016DTCORG4000
6/4/2016CTGPSNJ8000
6/4/2016OTSNUS3700
6/5/2016ABCLPS5600
6/5/2016VGSBHA2200

In this,

I have some records on 6/1/2016. the same record to be there in the following dates. The price is as mentioned. If the same record not in the another date, then the Price values to be replaced before record value.

Thanks.

1 Solution

Accepted Solutions
jayaseelan
Not applicable

Re: Replacing values in the next record..??

Hi Silambarasan,

     I have got your desired output.

      Please find the attachment.

Capture.PNG

Thanks

3 Replies
jayaseelan
Not applicable

Re: Replacing values in the next record..??

Hi Silambarasan,

     I have got your desired output.

      Please find the attachment.

Capture.PNG

Thanks

agni_gold
Not applicable

Re: Replacing values in the next record..??

Can you please provide your required result , that will help.

silambarasan130
Not applicable

Re: Replacing values in the next record..??

Thanks for the reply guys.

I got the expected output.