Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qliknewbie_1
Contributor II
Contributor II

Ideas on getting two different dates on two columns next to eachother by

Hi! 
I have a table with a bunch of measures, with currently two dimensions, week of year and day of week. 
My measures are either for that day of the current year or that day two years back. 
Now, I would like to add two more columns, one with the current year date and one with the previous year date. 

Does anyone know of a way to do this? 
If I just add det date, the number of rows becomes double as of course due to the current year date and previous year being different. Still I would like to keep them on the same row.

Adding a picture of what it looks like now:

qliknewbie_1_0-1661422275278.png

 

Any idea is greatly appreciated! Thanks!

 

Labels (3)
1 Reply
brunobertels
Master
Master

Hi 

This example APP may help you in the approach 

Note that this APP example is'nt my production : i stored it from the forum as it was one of my requierment 

(thanks to the original creator) 

Hope it helps