Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I want to switch the tables between today and yesterday.
What is the meaning of switch, Can you elaborate more this part
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)" ??
Try Date format like below
"=date(Vyesterday,'DD-MM-YYYY')"
Sorry doesn't work.
So i will solve it in the script.
But thank you for helping!
I don't think which you done in the script too
Qlik Community Tip: Marking Replies as Correct or Helpful