FTD data issue

[Anonymous]

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

[marcus_sommer]

Try: vFTD=MaxString(date(max(DATE)-1))

- Marcus

[Anonymous]

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

[marcus_sommer]

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

[Anonymous]

I will check!!

[Anonymous]

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

[marcus_sommer]

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

[Anonymous]

Okay I will try!