topic Re: Yesterday in QlikView

Yesterday

Wed, 28 Nov 2012 05:19:02 GMT

How to get the yesterday value from date field

eg:

Datefield

yesterday-11/27/2012

count(orders) for yesterday(11/27) is some x amount how to get this?

Re: Yesterday

Wed, 28 Nov 2012 05:23:48 GMT

Hi..

Today()-1=yesterday

if(datefield=Today()-1,Count(Orderes))

Hope it helps u

Regards,

Kabilan K.

Re: Yesterday

jagan — Wed, 28 Nov 2012 05:33:18 GMT

Hi,

You will get Yesterday date by subtracting 1 from todays date.

yesterdayDate = Today() -1

Internally the date is stored as number.

In expression you can use like this

=Sum({<DateDimension={'=$(=Today()-1)'}>} Sales)

Hope this helps you.

Regards,

Jagan.

Re: Yesterday

Anonymous — Wed, 28 Nov 2012 08:37:01 GMT

you can use

LET Vyesterday = today()-1;

expression :

=count({$<Day={$(=max(Day($(Vyesterday))))}>} orders)

Hope this helps you.

Regards,

Akbar

Re: Yesterday

Thu, 29 Nov 2012 03:45:12 GMT

i tried the above conditions its not working it shows null

order date is the date field

need to calculate the yesterday count(order) for order date.

Re: Yesterday

sivarajs — Thu, 29 Nov 2012 03:59:58 GMT

count({$<orderdate={"=$(=date(orderdate)-1)"}>}order)

Re: Yesterday

jagan — Thu, 29 Nov 2012 05:54:12 GMT

Hi,

Did you tried this

=Sum({<DateDimension={'=$(=Today()-1)'}>} Sales)

If it not works then check where there is any Date format mismatch.

Regards,

Jagan.