topic Macro wich select different values in QlikView

Macro wich select different values

Tue, 14 Feb 2012 09:56:26 GMT

HI All,

I have no knowlege with vbs.

I want that in a listbox every 10 seconds a different value is selected.

How can seen tha Macro therefor??

Thanks.

Re: Macro wich select different values

Anonymous — Tue, 14 Feb 2012 10:58:57 GMT

Hi Mahirceng,

Its not good to create the listbox selection based on the seconds(time) loop.

Here i attached one macro example file . I have it will be helping for your requirement to select the all listbox value individually using the macro.

Regards

Ashok

Re: Macro wich select different values

Tue, 14 Feb 2012 11:51:41 GMT

Hi Ashok thank you very much. Thats right.

It that possible without the msgbox ?? to put there something like sleep(10 seconds) next..or so??

But that is ok.

Regards

Re: Macro wich select different values

Anonymous — Tue, 14 Feb 2012 12:36:48 GMT

Hi Mahirceng,

Ya it is possible to do this without the msgbox.

I tried to select the listbox using the concept you need (sleep 10 seconds next so.. for).

But i cant able to get the solution for your requirement based on the time and may be its not possible to do that.

Regards,

Ashok

Macro wich select different values

Thu, 16 Feb 2012 22:56:07 GMT

Depending on what you're trying to do, you might be interested in the Animation functionality in QlikView. It can show you a graph chart while it successively steps through the values of a dimension field. That may be what you are trying to accomplish. I've used the animation feature to analyze graphs while it automatically steps through a series of dates, for example.

Macro wich select different values

Fri, 17 Feb 2012 09:46:47 GMT

Hello Tim,

hav u an example qvw, what you describe? I dont know this feature.

And knows somebody that an function like delayed or sleep () existing in VB, which i can use for my Macro above ??

I need this Macro without clicking on the msgbox, the selections should evry x-seconds changing.

This is for an demo app, where the user will nothing to select in a short präsentation in a fair.

Can someone help?? 🙂

Thanks

Re: Macro wich select different values

Anonymous — Fri, 17 Feb 2012 10:15:30 GMT

I have attached the macro qv file with the sleep time settings

Here you can understand the issue in the qv .

We cant see the what selection happening / going but finally it will reach the final listbox value

you can edit and see the macro from the edit module.

Regards

Ashok

Macro wich select different values

Fri, 17 Feb 2012 12:45:04 GMT

Thank u ashok,

now i understand u, it is not very nice when the user dont see the result of the chooses.

In this qvw we only can see the result of last value in the listbox.

It would be perfect, when we can see the results of every selection, which changing in x-seconds.

Do you know how the syntax of delayed is?? Perhaps we can do this with delayed istead of sleep

Regards,

Mahir

Macro wich select different values

Anonymous — Fri, 17 Feb 2012 12:50:38 GMT

I am not sure we can do it but will try to done it soon

Regards

Ashok