Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Compare data with previous day

Hi,

I would like to compare the data of the currently selected date with the data from the previous day.

DateNamereference
07/01/2012Jane ZDH344
08/01/2012Jane ZED322
07/01/2012Carol PPK123
08/01/2012Carol PPK123

I want a table that will only show the Date, Name and reference of the selected date. But I want to formatt the reference text if the reference changed from the previouse date. The table below shows how I want my data to look

DateNameReference
08/01/2012Jane ZED322
08/01/2012Carol PPK123

I havent been able to find a current disscussion on this that doesnt include set analysis and seeing as I am not performing aggregation to the Reference field I didnt think set analysis was appropriate for this.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

Thankyou it worked perfectly!!

Thankyou for being so fast too!!

Highlighted
Contributor
Contributor

hi Wassenaar,

 

i have one data table has date and deal_number two columns,  and some sample data like below. There are many values for the date field  and deal_number, i just put two days data as sample.

for the adjacent two days, i want to compare the deal_number, if the deal_number only exists in the date 05-06, the record will be noted as "NEW", if the deal_number exists in both date 05-06 and 05-05 will be noted "FORWARD", and if the deal_number only exists in the date 05-05, the record will be noted as "OLD", and for all date, i need achieve this compare. 

datedeal_number
......
2019-05-06a001
2019-05-06a002
2019-05-06a003
2019-05-05a004
2019-05-05a003
2019-05-05a005
......

 

The expected result likes, i hope i have made it clear, and is there any suggestion on this? thanks a lot

datedeal_numberResult
...... 
2019-05-06a001NEW (only exist in 6-6)
2019-05-06a002NEW (only exist in 6-6)
2019-05-06a003FORWARD (exist in both days, 6-5 and 6-6)
2019-05-05a004OLD (only exist in 6-5)
2019-05-05a003FORWARD
2019-05-05a005OLD (only exist in 6-5)
......