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.

[Anonymous]

I want to switch the tables between today and yesterday.

[Anil_Babu_Samineni]

What is the meaning of switch, Can you elaborate more this part

[Anonymous]

I want to have two boxes:

one is called today and should select my calender (Export_Zeitstempel_Anzeige_Tag) shon in a listfield to today.

the other box sould select my calender to yesterday.

Is it possible to set my listfield called: Export_Zeitstempel_Anzeige_Tag

to a variable which I set in the script by  "=date(Vyesterday,DD-MM-YYYY)"  ??

[Anil_Babu_Samineni]

Try Date format like below

"=date(Vyesterday,'DD-MM-YYYY')"

[Anonymous]

Sorry doesn't work.

So i will solve it in the script.

But thank you for helping!

[Anil_Babu_Samineni]

I don't think which you done in the script too

Qlik Community Tip: Marking Replies as Correct or Helpful