Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i would like to know whether it is possible to loop through text boxes.
i have several containers that are dependent on a single field ProductID, i would like to know whether one is able to combine these text boxes into a single container and simply allow the values to loop through the different values in the field.
also if it is not possible to loop through values in a field, would one be able to loop through textboxes that have been placed in another container?
i have attached a screenshot of the containers
1) Create a Variable , say vToggleSelect
2) vToggleSelect = =if(second(now())>40,'US',if(second(now())>20,'UK','Japan')) // Just for example
3)Go to Document Settings >> Triggers >> Variable triggers >> Select vToggleSelect >> onChange Actions >>
a)Clear Field : enter name of field
b)Select in field: Field name and Value, =vToggleSelect
Now from 0 - 20 seconds value selected will be Japan, after 20 seconds value selected will UK and after seconds US
what do you mean by loop thru, what are you trying to achieve?
As you can see i have 6 different containers, each are based on a selected product ID, i would like to combine all 6 containers into a single container, this single container should than display each block, and than change to the next after a short time interval.
similar to an animation, i am unsure whether qlikview has that capability
It can be changed on click of a button . But based on interval of time?? Can you share the qvw for us to try??
I understand it can be changed on a click of a button, but i am looking for it to be automated. unfortunately i am unable to share the QVW as it has client sensitive information.
I have an idea but not sure if it works perfectly. Take a variable with timestamp say vTimestamp and again take another variable and use it for the conditional layout like if vTime >= vtimestamp and VTime < vTimestamp+5 (Here 5 is the duration you want the object to appear.) and for the next object condition as vTime >= vtimestamp +5 and VTime < vTimestamp+10. and so on...
Just sharing a thought. Let's see if there is any other solution.
Thanks let me try that out
1) Create a Variable , say vToggleSelect
2) vToggleSelect = =if(second(now())>40,'US',if(second(now())>20,'UK','Japan')) // Just for example
3)Go to Document Settings >> Triggers >> Variable triggers >> Select vToggleSelect >> onChange Actions >>
a)Clear Field : enter name of field
b)Select in field: Field name and Value, =vToggleSelect
Now from 0 - 20 seconds value selected will be Japan, after 20 seconds value selected will UK and after seconds US
Okay so i've created the variable vToggleSelect with inputs relevant to the Field name ProductID
vToggleSelect =if(second(now())>40,'Huawei P8 Lite',if(second(now())>20,'Huawei P9 Lite','Landline'))
To test it out i created a textbox with the following expression
=count({<ProductID = [vToggleSelect]>}ID).
This gives me a value of 0.
whereas it should give me a value of 440 for landline, 381 for P8 and 6703 for P9
Your Expression is missing {},
=count({<ProductID = {"$(vToggleSelect)"}>}ID).
if you just want to verify the variable if it's changing with the seconds, just add =vToggleSelect in the textbox