Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

philmywallet
New Contributor III

Next Day Button

Hi

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

Tags (3)
1 Solution

Accepted Solutions

Re: Re: Next Day Button

Hi

PFA

7 Replies
sujeetsingh
Honored Contributor III

Re: Next Day Button

write like this

take a variable and when click assign a value like 1

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

philmywallet
New Contributor III

Re: Next Day Button

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

Hi

PFA

Not applicable

Re: Next Day Button

Find attachment hope this will help you.

er_mohit
Honored Contributor II

Re: Next Day Button

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

Not applicable

Re: Next Day Button

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).

philmywallet
New Contributor III

Re: Next Day Button

Hi

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

Community Browser