Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I am trying to show data for single day for which I created variable as below:
vFTD = MaxString(date(Today()-1))
and used in set analysis as DATE={'$(vFTD)'}
This works fine .
However now I want to incorporate selections on Day field as well.
Like if Day is selected as 15th then data for 14th is shown. Above expression works only for current day as today() is used.
Hence I tried vFTD as vFTD=MaxString(date(DATE-1)).
However it does not work. Is there anything wrong in this which needs to be changed?
Thanks in advance for your help.
Thanks & Regards
Chintan
Try: vFTD=MaxString(date(max(DATE)-1))
- Marcus
Hello Marcus
Thanks for your reply.
It does not work. I also tried as below:
vFTD=date(max(DATE)-1).
However it shows previous day in text box.
Thanks & Regards
Chintan
Is the format from: date(max(DATE)-1) different to the formatting of the field DATE? If yes than extend the date-function to a format-string to get the same formatting like in DATE.
- Marcus
I will check!!
Hello Marcus
I have brought the DATE in 'DD-MM-YYYY' format.
vFTD=MaxString(date(DATE)) works fine to give data of the date selected .
But vFTD=MaxString(date(DATE-1)) does not give me output for the previous day.
Regards
Chintan
Use respectively create a table-chart and use no label for your expression and then you could see in the label-field how qlik does interpret the expression. Further do a check if DATE is really a date and not a formatted timestamp.
- Marcus
Okay I will try!