Date Formula

[KC3]

Hi Qlikians,

I stuck to get the data.

I want the data in a way where my Market Place will be on Column with Yesterday and Total.

Can someone please help me for that.

PFB image day breakup is there i need only yesterday and total.

[rubenmarin]

Hi, if you only want 2 columns by market place it will be better to remove the date dimension and use 2 measures: one for total and another for yesterday, in example:

Total: Sum(Sales)

Yesterday: Sum({<Date={$(=Date(Today()-1))}>} Sales)

[KC3]

Hi Rube,

I am getting Null value as result can you please take a look into it.

PFB SS for the same.

Formula applied

Result-

[rubenmarin · Accepted solution]

Hi, dates has always the complication of the different formats 

You can try with single quotes: Sum({<Date={'$(=Date(Today()-1))'}>} Sales)

Or double: Sum({<Date={"$(=Date(Today()-1))"}>} Sales)

Or converting to num:  Sum({<Date={$(=Num(Date(Today()-1)))}>} Sales)

Or a mix of the previous.

[KC3]

Thanks Rube for the help

[KC3]

Hi,

Earlier I was getting the proper answer, but i marked in the time of month start the data is showing null value, starting Nov i was facing the same issue.