Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
maniram23
Creator II
Creator II

date function help

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

2 Replies
sinanozdemir
Specialist III
Specialist III

Maybe something like this:

Capture.PNG Capture2.PNG

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

Capture3.PNG

And the below script for the label:

Capture4.PNG

I am also attaching the qvw.

Hope this helps.

Anonymous
Not applicable

Hi,

Try this

=num(today()-7)