topic Re: last 21 days - button in QlikView

last 21 days - button

Anonymous — Sun, 19 Nov 2017 04:54:51 GMT

hi,

i want a button that chose the last 21 days.

the feild is "date"

how i need to wrote it ?

thanks'

yarin

mdmukramali — Sun, 19 Nov 2017 05:37:21 GMT

Hi,

use the below expresstion in Search String.

='>' & Date(Today()-21,'DD/MM/YYYY') & '<=' & Date(Today(),'DD/MM/YYYY')

PFA.

Thanks,

Mukram.

vishsaggi — Sun, 19 Nov 2017 05:45:38 GMT

Just create a variable for 21days like

Click Ctrl+Alt+V

Then add v21Days as variable name. Then

= Date(Max(YourDate) - 21, 'MM/DD/YYYY')

Then use something like this.

Making sure you got your data format correctly.

LOAD *,

Date(Date#(Date, 'MM/DD/YYYY'), 'MM/DD/YYYY') AS YourDate

From ......;

Then create a button and in Action tab add Select in Field and add your fieldname as YourDate then use below expession:

= '>=' & v21Days