topic Dynamic Chart - New Fields on Event in QlikView

Dynamic Chart - New Fields on Event

Wed, 05 Jan 2011 10:56:15 GMT

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

Dynamic Chart - New Fields on Event

prieper — Wed, 05 Jan 2011 11:04:55 GMT

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

Peter

Dynamic Chart - New Fields on Event

Wed, 05 Jan 2011 11:23:04 GMT

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, 🙂

Dynamic Chart - New Fields on Event

Wed, 05 Jan 2011 11:28:26 GMT

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

Dynamic Chart - New Fields on Event

Wed, 05 Jan 2011 11:44:38 GMT

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

Dynamic Chart - New Fields on Event

Wed, 05 Jan 2011 12:22:44 GMT

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

Dynamic Chart - New Fields on Event

Wed, 05 Jan 2011 12:58:15 GMT

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