Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Writing a Macro in QV

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.

1 Solution

Accepted Solutions
Not applicable
Author

I will check it out, thank you.

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

View solution in original post

2 Replies
flipside
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

I will check it out, thank you.

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