topic Re: Function to Move TEXT Object dynamically ? in QlikView

Function to Move TEXT Object dynamically ?

Mon, 15 Apr 2013 16:58:57 GMT

Hello Every one,

I want to move Text object dynamically based upon Selection from List Box.

e.g. List Box contains 8 Country

1. Japan

2. Germany

3. USA

4. UK

5. China

6. Russia

7. Taiwan

8. France

If some one selects ONLY Japan or ONLY USA or ONLY Germany or any ONE of the anove Country, Postion of the TEXT Object will be x=230 & Y=100

However, if Some one Select Multiple Country, JAPAN Text Object will be at x=230 & Y=100, and USA will be x=260 & Y=120 and so forth so on.

Please note:

I am not sure if there is any function that I can use to move these text object dynamically
I am also not sure if there is better way to move the object dynamically.

I appreciate any insight in this matter.

Anonymous — Mon, 15 Apr 2013 17:55:29 GMT

Moving object is possible by creating a macro which would evaluate the conditions, and assign position parameters.

I think it is better to create multiple text boxes in the appropriate positions, and conditionally show only one at a time.

Regards,

Michael

Mon, 15 Apr 2013 19:03:50 GMT

hmmmm. I am still new bee, so Macro is long way to go.

I will explore second option but that would require very complex IF Condition.

I appreciate, if you can provide me basic syntax to get going. I suppose it would be something like,

TEXT object # 1=> if (Country='US')

TEXT object # 2=> ? ? ? ( assuming some one select US & JAPAN)

TEXT object # 2=> ? ? ? ( assuming some one select US & JAPAN & GERMANY)

Anonymous — Mon, 15 Apr 2013 19:47:08 GMT

See attached example.

Notice the tesxt boxes text and also show conditions. Hope it helps...

Regards,

Michael

Mon, 15 Apr 2013 22:10:15 GMT

Michael,

You are brilliant. Hats off. This example opens up my imagination

THANK YOU !

Anonymous — Tue, 05 May 2015 10:25:29 GMT

Hi Michael,

The solution is amazing, we tried the same with graphs instead of text boxes it is not working fine, can you please suggest how to proceed on this.

Thank you