Dynamic Chart - New Fields on Event

[#1]

Hello!

I am relatively new to Qlikview and I am looking help in how to program the following scenario.

The business sponsor wants to see two different lots of information on the same pivot table (chart), but not at the same time. They want to click on a button that will replace two, side-by-side, columns with two new expression columns and of course, when they click the button again it will restore the table back to its default setup.

I understand I must do the following.

• Create a button
• Add a macro
• Prefabricate the expression columns

What I need help with is the macro.

Thanks,

Andrew

[prieper]

What about creating two reports, of which only one is visible (toggle with macro)?

Peter

[#3]

Thanks for you quick response.

Yes, technically that will do it but I would be concerned that the transition between charts would be messy with objects popping up and moving over the screen. The BA has been very specific about what they want this time.

Thanks, 🙂

[#4]

you can also work with out using macro.

1. Create a button

2. In chart property under Layout > show >conditional .

3. Use Variable here i:e when you have to display which graph and same should be on button.

tell if you need any more inputs..........

Regards

Ashwin

[#5]

Ashwin, thanks.

I have my button on the page and it is named 'Toggle to Values' and I have found the Layout tab with the show condition; however, I don't easily see the correlation between them both. I can understand the button firing a macro or setting a flag, but I don't know how to utilise it in Qlikview through the suggested root.

Can you advise how I would state the following pseudo code in a macro?

if (flag1) then

with chart1

.field(x).hide

.field(x).show

end with

end if

[#6]

I don't know to attach file on Fourm.

please give me your mail iD i will send you demo i have created fot you.

ashwinpagare1985@gmail.com

[#7]

Try using this application .It does not require any Macro !!!!