topic Re: Count Yesterday? in QlikView

Count Yesterday?

knightwriter — Wed, 05 Aug 2015 10:04:45 GMT

Hi All,

I am trying to count the number of cars sold 'yesterday' after I refresh my dashboard on a daily basis.

How do I show this in a straight table and in a text object?

The expression I have tried is;

=count(distinct(if (InDay ([Cars]='Sold, Today(), -1), [Car Id], )))

Many thanks

sunny_talwar — Wed, 05 Aug 2015 10:07:39 GMT

May be this:

=Count({<Date = {"$(=Date(Max(Date) - 1))"}>}DISTINCT [Car Id])

Kushal_Chawda — Wed, 05 Aug 2015 10:08:05 GMT

try,

count({<Cars ={'Sold'},Date ={"$(=date(today()-1,'Yourdateformat'))"}>} distinct [Car Id])

qlikmsg4u — Wed, 05 Aug 2015 10:08:43 GMT

try this

=Count({<Date = {"$(=max(Date)-1)"}>}Distinct Carid)

Wed, 05 Aug 2015 10:12:20 GMT

count({<Cars ={'Sold'},Date ={"$(=Date(Max(Date) - 1))"}>} distinct [Car Id])

knightwriter — Thu, 06 Aug 2015 13:40:12 GMT

Hi All,

thanks for your comments.

I used

=count(distinct(if(Inday([Cars], Today(), -1) and [Car status]= 'Sold', [Car type], )))