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: 
ilze2
Partner - Contributor II
Partner - Contributor II

Shifted graph

Hello!
I want to make graph, which is shifted by date. It means, in chart would be 2 lines: one shows current values, another values of previous day.
I tried something like:
if(Date = date($(vDat)), Sum({<Date = {"=date($(vDat)-1)"}>} page_impressions))
where vDat is date as number, but it does not work. What I am doing wrong?
Thank You in advance!

Labels (4)
2 Replies
Thiago_Justen_

Hi there,

Please take a try:

if(Date = date('$(vDat)'), Sum({<Date = {"$(=date(`$(vDat)`)-1)"}>} page_impressions))

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
ilze2
Partner - Contributor II
Partner - Contributor II
Author

Sorry, it does not work