topic Re: Next Day Button in QlikView

Next Day Button

Anonymous — Mon, 25 Nov 2013 11:52:53 GMT

I have created a calender in the dashboard for a date dimension which works fine, however it would be useful if I had a next day & Previous day action button so users can click forward or back based on the date shown in the calender.

Any thoughts?

Phil

Re: Next Day Button

sujeetsingh — Mon, 25 Nov 2013 11:55:54 GMT

write like this

take a variable and when click assign a value like 1

=if(variable='1',Date-1,Date)

Re: Next Day Button

Anonymous — Mon, 25 Nov 2013 12:06:07 GMT

Just to be a bit clear, I am wanting to change the selection based on the next / previous day button.

Thanks

Phil

Re: Re: Next Day Button

MayilVahanan — Mon, 25 Nov 2013 12:07:20 GMT

PFA

Re: Next Day Button

Mon, 25 Nov 2013 12:14:56 GMT

Find attachment hope this will help you.

Re: Next Day Button

er_mohit — Mon, 25 Nov 2013 12:32:21 GMT

in action there is always by default having action forward or previous

you just call it to make a button add action

selection-->forward

and other for back

Re: Next Day Button

Mon, 25 Nov 2013 16:04:19 GMT

I also use fast selection button for previous month or week. What I would do for previous day > button > action > select in field > field: date field > value: =Today()-1 (of course, if this doesn't work, check the date format and adjust the function accordingly)

In the caption tab I would put some help text, like "previous day". In the button I would only put "<" (or ">" for next day).

Re: Next Day Button

Anonymous — Mon, 25 Nov 2013 16:10:27 GMT

It took a little bit of fidling with in my own dashboard but I got it working eventually. The issue I found was that my date field had date & time, so it didn't like the format, but since I created a Date(Date) expression in the script it works great.

Thankyou for your help it was extremely useful

Phil