Count Yesterday?

[knightwriter]

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]

May be this:

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

[Kushal_Chawda]

try,

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

[qlikmsg4u]

try this

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

[#5]

Hi

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

[knightwriter · Accepted solution]

Hi All,

thanks for your comments.

I used

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