Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

after clicking the button action should perform

Hi,

I had two input boxes, contains of start date and end date. Ex: i'm selecting 21-05-2011 in first input box and 22-05-2011 in second input box.  Along with this i had a button. After clicking this button the Start Date and End Date should reflect in file.

And my file contains a bar chart, that should not be changed  when the dates are selecting, it should be done after clicking on the button. i.e: After clicking the button the chart should display values from 21-05-2011 to 22-05-2011.

Thanks in advance.

Thnks

2 Replies
Not applicable
Author

Hi,

Another way to do this is to create start and end date through variables and input fields and use them into the bar chart. Then you don't have to have a button...

/@Ungvall

Anonymous
Not applicable
Author

What you can do is make 2 variabels (fe vStart and vEnd) in and input box.

Then make your button with the action that starts the following macro:

sub SelectDatum

    ActiveDocument.ClearAll false

    First= ActiveDocument.Variables("vStart").GetContent.String

    Last= ActiveDocument.Variables("vEnd").GetContent.String

    mySelect= ">" & First & " <" & Last

    ActiveDocument.Fields("datum").Select mySelect

end sub

Where "datum" is the name of your date field