Writing a Macro in QV

Mon, 29 Oct 2012 11:21:53 GMT

Hi everyone,

I am trying to create a routine that will manage how/what QV report will show up in my sheet, and wondeirng if someone can point me to the right direction.

Suppose that I have two variables x and y where x in (1,2,3) and y in (4,5,6), and there are 9 tables t14, t15, t16, t24, t25, t26, t34,t35, and t36 associated (x,y). As you can see, they are completely determined by the ordered pair (x,y), and what I would like to do is to maximize table one table and minimize other tables. For example, when x=1 and y=4, I would like to maximize t14, and hide the others. I have tried "action" option in QV, but it does not seem to work well, and wondering if there is a way to write a macro in QV.

Thank you.

p.s. I also attached a mock qvw file here.

Re: Writing a Macro in QV

flipside — Mon, 29 Oct 2012 11:30:38 GMT

Would using Conditional Show work for you?

If so, layout each table where you want it to display, then set the Conditional show to ...

x=? AND y=?.

flipside

Re: Writing a Macro in QV

Mon, 29 Oct 2012 11:35:56 GMT

I will check it out, thank you.

p.s. I just uploaded a mock qvw file.

topic Writing a Macro in QV in QlikView

Writing a Macro in QV

Re: Writing a Macro in QV

Re: Writing a Macro in QV