How to switch between today and yesterday

[Anonymous]

Good morning all,

i have the following problem:

I have data with a calender-dates.

day(Export_Zeitstempel)&' '&month(Export_Zeitstempel)&' '&Year(Export_Zeitstempel) as  Export_Zeitstempel_Anzeige_Tag,

My calender is called: Export_Zeitstempel_Anzeige_Tag

Now, I would like to visualise two text-bosxes which switch between today and yesterday.

My solution was:

for today:

=MaxString(Export_Zeitstempel_Anzeige_Tag)

for yesterday:

=(MaxString(Export_Zeitstempel_Anzeige_Tag))-1

Both doesn't really work.

Any ideas? Thank you for helping.

[antoniotiman · Accepted solution]

Hi Robert,

If  Export_Zeitstempel is Date Field

in script

Date(Export_Zeitstempel,'DD MM YYYY') as Export_Zeitstempel_Anzeige_Tag

Yestarday

Date(Max(Export_Zeitstempel_Anzeige_Tag) -1)

Regards,

Antonio

[qlikview979]

Hi  may be this

Today:-

DATE(max(Export_Zeitstempel_Anzeige_Tag))  as Today

Yesterday

DATE(max(Export_Zeitstempel_Anzeige_Tag)-1)  as Yesterday

Regards,

Mahesh

[Anonymous]

for today:

=MaxString(Export_Zeitstempel_Anzeige_Tag)

for yesterday:

=Date((MaxString(Export_Zeitstempel_Anzeige_Tag))-1)

[Anonymous]

Thank you, but it doesn't work.

[Anonymous]

THX!

It is working fot today;

but not for yesterday.

[antoniotiman]

Can You share any values of Export_Zeitstempel in Your Data ?

[jagan]

Hi,

Try like this

=Date(Date(MaxString(Export_Zeitstempel_Anzeige_Tag))-1)

Regards,

jagan.

[Anonymous]

sorry, doesn't work.

[qlikview979]

may be this will work

DATE(max(Export_Zeitstempel_Anzeige_Tag)-1)  as Yesterday