topic Re: FTD data issue in QlikView

FTD data issue

Anonymous — Wed, 22 Mar 2017 09:37:09 GMT

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

Re: FTD data issue

marcus_sommer — Wed, 22 Mar 2017 09:40:15 GMT

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

- Marcus

Re: FTD data issue

Anonymous — Wed, 22 Mar 2017 09:50:30 GMT

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

Re: FTD data issue

marcus_sommer — Wed, 22 Mar 2017 09:57:52 GMT

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

Re: FTD data issue

Anonymous — Wed, 22 Mar 2017 10:09:22 GMT

I will check!!

Re: FTD data issue

Anonymous — Wed, 22 Mar 2017 10:45:32 GMT

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

Re: FTD data issue

marcus_sommer — Wed, 22 Mar 2017 11:35:43 GMT

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

Re: FTD data issue

Anonymous — Wed, 22 Mar 2017 11:43:21 GMT

Okay I will try!