topic Re: Looping through textboxes in QlikView

Looping through textboxes

Tue, 04 Apr 2017 05:49:47 GMT

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

Re: Looping through textboxes

vinieme12 — Tue, 04 Apr 2017 06:23:05 GMT

what do you mean by loop thru, what are you trying to achieve?

Re: Looping through textboxes

Tue, 04 Apr 2017 06:28:46 GMT

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

Re: Looping through textboxes

Anonymous — Tue, 04 Apr 2017 06:44:20 GMT

It can be changed on click of a button . But based on interval of time?? Can you share the qvw for us to try??

Re: Looping through textboxes

Tue, 04 Apr 2017 06:47:19 GMT

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.

Re: Looping through textboxes

Anonymous — Tue, 04 Apr 2017 07:00:40 GMT

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.

Re: Looping through textboxes

Tue, 04 Apr 2017 07:01:34 GMT

Thanks let me try that out

Re: Looping through textboxes

vinieme12 — Tue, 04 Apr 2017 07:03:05 GMT

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

Re: Looping through textboxes

Tue, 04 Apr 2017 08:45:40 GMT

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

Re: Looping through textboxes

vinieme12 — Tue, 04 Apr 2017 08:47:52 GMT

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

Re: Looping through textboxes

Tue, 04 Apr 2017 08:56:22 GMT

Thanks works perfectly now.