topic Re: Date function help in QlikView

Date function help

maniram23 — Mon, 10 Aug 2015 12:31:16 GMT

Hi,

i have one date field in my data.and some id,sales of data is there.

here if i select any date it has to go 7 days back for example

if i select 07/01/2005 it has to show 01/01/2015

same way if i select 01/01/2015 it has to show 25/12/2014 of data.

i have some ideas but those ideas are not giving proper result.

any ideas.

thanks in advance

sunny_talwar — Mon, 10 Aug 2015 12:33:15 GMT

Where does it need to go back 7 days? In a chart? In a text box object? In script? Please provide more details for a better response.

Thanks,

Sunny

maniram23 — Mon, 10 Aug 2015 12:38:39 GMT

Hi it has to show in chart.

sunny_talwar — Mon, 10 Aug 2015 14:11:32 GMT

May be this within your set analysis statement:

{<Date = {"$(=Date(Max(Date) - 7, 'YourDateFieldFormat'))"}>}

Mon, 10 Aug 2015 14:21:44 GMT

Hi Mani,

Ya The above one will give the result

{<Date = {"$(=Date(Max(Date) - 7, 'YourDateFieldFormat'))"}>}