topic Changing Chart Expression in QlikView

Changing Chart Expression

Tue, 05 Jul 2011 21:21:28 GMT

Hello,

I was wondering if there was a way to change the expression of a chart based on creating a button. So for example, if at first I wanted to show a line graph summing total revenue, and then I could somehow disable that expression, and enable the next expression summing total seats billed.

Thanks for your help,

Alex

Changing Chart Expression

Tue, 05 Jul 2011 21:28:41 GMT

Hi there,

Can you send us a sample data set?

So that we can give a try along with your requirement.

Thanks,

Bikash

Changing Chart Expression

Tue, 05 Jul 2011 21:39:32 GMT

Hi Afronczek.

Maybe you can group the 2 Expressions:

Create the SUM(Revenue) as first expression,

create the SUM(Seats) as Second expression. Then selecting the second expression clik on the "Group" Button, you will be capable to change between your 2 expression in the same chart.

Hope this help.

Regards

Re: Changing Chart Expression

IAMDV — Wed, 06 Jul 2011 05:18:47 GMT

Hi Alex,

I hope you are doing well.

Yes, this is possible in two ways.

1. As mentioned above by Emmanuel Prieto. You can group your expression & dimensions.

2. If you wanted to change the expression on button click. Then you need write VB Script using the API Guide. I have an example at work and I can share them with you, if you wanted take this approach.

Hope this helps!

Cheers - DV

Changing Chart Expression

Wed, 06 Jul 2011 13:16:30 GMT

Hello DV,

Thanks for all your previous help, and thanks Emmanuel for this correct answer.

Alex