Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

a little question

Good morning all,

in my application a have an inputbox for actual year and a year for comparsion.

error loading image

Now I wont do give the users with drop down option, only values which I found in my tables. I'm

sure it's possible, but I cannot find the right solution.

thx

wmr

6 Replies
sathishkumar_go
Partner - Specialist
Partner - Specialist

Hey whats the problem u r facing? can u explain clearly?

-Sathish

Not applicable
Author

Hello,

I dont want to put the year manually in the box, I want to find a formula, so the ist always the right values in the box.

Instead of the fixed values "2006", "2007" and "2008", I want all possible values of the table i had read.

gruß

wmr

Ins

Not applicable
Author

hi WolfgangMRoser

why dont you use SLIDER instead of input box?!? then you can assign calendar to it for a variable and using the value of it.

i dont suggest this way you are going cuz you would have problems with DATE data type

hamid

Not applicable
Author

so you can choose values (in DATE format) between i.e year 2008 and 2009

Anonymous
Not applicable
Author

From the information provided, I don't see a reason for using variables here. It would be more convenient to use fields in a logical islands, with property "only one value selected", so it would be easy to read the data into these fields.

Not applicable
Author

Hello,

it is possible to do in this way, but than it necessary to change the values every year.

gruß

wmr