topic Re: Show the values of yesterday in QlikView

Show the values of yesterday

Thu, 04 Aug 2016 06:44:45 GMT

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?

Re: Show the values of yesterday

Frank_Hartmann — Thu, 04 Aug 2016 06:51:22 GMT

see attached sample

SET vToday ='Today()';

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

in textbox use:

date(vYesterday)

hope this helps

Re: Show the values of yesterday

avinashelite — Thu, 04 Aug 2016 06:59:16 GMT

may be like this

SET vToday = Today();

SET vYesterday = Today()- 1;

Re: Show the values of yesterday

antoniotiman — Thu, 04 Aug 2016 07:00:14 GMT

Let vToday = Today();

Let vYestarday = Date(vToday -1);

Re: Show the values of yesterday

Thu, 04 Aug 2016 07:17:12 GMT

please try this

Let Vtoday=Today();

Let Vyesterday= Today()-1;

textbox:

=Date($(Vyesterday))