topic Re: date function help in QlikView

date function help

maniram23 — Mon, 10 Aug 2015 18:02:59 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 & 07/01/2005 date.

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

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

any ideas.

thanks in advance

sinanozdemir — Mon, 10 Aug 2015 18:36:41 GMT

Maybe something like this:

In order to achieve this, I used the below script for expression:

And the below script for the label:

I am also attaching the qvw.

Hope this helps.

Anonymous — Mon, 10 Aug 2015 18:37:55 GMT

Hi,

Try this

=num(today()-7)