Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.