topic Re: Taking user input to update variables in QlikView

Taking user input to update variables

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Taking user input to update variables

beck_bakytbek — Mon, 17 Apr 2017 21:07:29 GMT

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

Re: Taking user input to update variables

Mon, 17 Apr 2017 21:30:14 GMT

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!

Re: Taking user input to update variables

Mon, 17 Apr 2017 21:41:38 GMT

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!

Re: Taking user input to update variables

beck_bakytbek — Mon, 17 Apr 2017 21:53:07 GMT

Super, main thing, you solved your issue

Re: Taking user input to update variables

Abhishekb — Mon, 25 Sep 2023 11:36:58 GMT

Hi Wendy,

Thanks for the solution. It helped for my problem.