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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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