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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Taking user input to update variables

Hi everyone,

I have created some let variables in the script and I want to be able to update them based on the user's input, is it possible?

vtd - user input date;  right now is set to today()

vYear - getting the year based on vtd

vMonth - getting the month based on vtd

so if the user want to change vtd to 3/15/2016, vYear would change to 2016, vMonth change to 'Mar' ideally.

is it possible?

thanks in advance!

1 Solution

Accepted Solutions
Not applicable
Author

I think I figured it out!

instead of creating the variables in script, I used the Settings -> Variable Overview  and it worked!

thank you Beck!

View solution in original post

5 Replies
beck_bakytbek
Master
Master

Hi Wendy,

what is your expected output, this way of proceeding is possible, but cumbersome,

look at this functon: QlikView Tutorials | How to create and configure InputField in QlikView - YouTube

maybe you can solve your issue in another way

beck

Not applicable
Author

Hi Beck,

Thank you for replying.

Right now I have created many let variables that depends on variable "vtd".

let vtd=today(); //today's date
let vMonth = month(vtd); //month of latest updated week
let vYear= year(vtd); //year of latest updated week

let vFirstDayofYear = MakeDate(vYear,1,1); //January,1 of current year

As you can see, vtd is set to today's date whenever I reload.

However, my goal is for the user to be able to change variable vtd and have the other variables change accordingly.

Hope that makes sense. I've very new at this, so I might have done this completely wrong...

thanks!

Not applicable
Author

I think I figured it out!

instead of creating the variables in script, I used the Settings -> Variable Overview  and it worked!

thank you Beck!

beck_bakytbek
Master
Master

Super, main thing, you solved your issue

Abhishekb
Contributor III
Contributor III

Hi Wendy,

Thanks for the solution. It helped for my problem.