Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mandilicious
Creator II
Creator II

Adding Last year values in advance into the colum

Hi All,

Please help. I would like to have last year values to be added in advance into Last year column?

Below is how report look like.

mandilicious_0-1695024863727.png

Regards

 

Labels (1)
7 Replies
mandilicious
Creator II
Creator II
Author

Please help 

 

G3S
Creator III
Creator III

please provide a sample dataset and also an example of the output you are looking for?

mandilicious
Creator II
Creator II
Author

Thank you very much for your respond. I really appreciate it.

Below is an example of my output. Last year data is existing so i would like it to be prepopulated for there entire weekdays and as for Actual orders they will come daily is fine.

mandilicious_0-1695106717822.png

 

brunobertels
Master
Master

hi 

 

May be this 

sum( {<Date = {'=$(addyears(Date,-1))'}>}

mandilicious
Creator II
Creator II
Author

Hi Brunobertels,

Thank you for your help.

I used what you shared but it does not pre-populate the last year values,

Below is what is the true picture from dashboard.

 

mandilicious_0-1695135351487.png

My delivery Date start tomorrow which i expected Actual Order to be zero and Last Year orders to be pre-populated like below table.

I guess i need to pre-populate the Delivery Date as well to be able to get Last Year Orders?

Delivery Date Weekday Actual Orders Last Year Orders
20/09/2023 Wed 0 500
21/09/2023 Thu 0 400
22/09/2023 Fri 0 300
23/09/2023 Sat 0 200
G3S
Creator III
Creator III

do you have the dataset for last year? 

are you looking to match the day+month to be the same but year to be last year?

mandilicious
Creator II
Creator II
Author

Hi G3S

Yes, i am looking to match the day+month to be the same but year to be last year.

Regards