Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show the values of yesterday

Dear all,

I would like to create a textbox that shows the value of today and yesterday. So therefore I have created the following two variables:

SET vToday = Today();

SET vYesterday = vToday- 1;

However, when I create a text box now in which I would like to show the value of vYesterday I get a " -"  value. Any thoughts on how I can perform operations ( + / - days) on a date variable?

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

see  attached sample

SET vToday ='Today()';

LET vYesterday = '=$' & '(vToday)' & '-1';

in textbox use:

date(vYesterday)

hope this helps

View solution in original post

4 Replies
Frank_Hartmann
Master II
Master II

see  attached sample

SET vToday ='Today()';

LET vYesterday = '=$' & '(vToday)' & '-1';

in textbox use:

date(vYesterday)

hope this helps

View solution in original post

avinashelite

may be like this

SET vToday = Today();

SET vYesterday = Today()- 1;

antoniotiman
Master III
Master III

Let vToday = Today();

Let vYestarday = Date(vToday -1);

Not applicable

please try this


Let Vtoday=Today();

Let Vyesterday= Today()-1;

textbox:

=Date($(Vyesterday))