topic Re: Dynamic Chart (VB Script) in QlikView

Dynamic Chart (VB Script)

IAMDV — Sat, 21 May 2011 08:26:32 GMT

Dear All,

I have a requirement to generate 4 dynamic charts based on the user selection. So I had decided to use $Field to display all dimension fields and then I wanted the user to select dimensions. Then my charts should populate based on the dimension.

I had started to write some VB Script but I need more help on this...

Sub Dynamic_Chart_Dimension_01

Set MyChart = ActiveDocument.GetSheetObject("CH67")

MyChart.SetReference

MyChart.AddDimension "Gender" -- This line of code now adds dimension

MyChart.AddExpression "COUNT(Resp_ID)" -- This line adds expression

End Sub

~Here is what I need...

1. I wanted to check if there is already dimension then the VB Script should replace the Dimension. However, if there is no Dimension then we need to add one. So it should simple IF, ELSE & End IF construct.

2. Instead of using "Gender" as dimension I wanted an expression... something like the first selection from the list box. And for the next Chart the script should take the second selection from the list box.

Many thanks in anticipation!

Cheers - DV

Re: Dynamic Chart (VB Script)

kaushiknsolanki — Sat, 21 May 2011 10:54:18 GMT

Hi,

I am here by uploading an example.

Hope this is what you are looking for

Regards,

Kaushik Solanki

Dynamic Chart (VB Script)

IAMDV — Sat, 21 May 2011 13:50:07 GMT

Kaushik - Thanks mate. This is almost what I wanted to do... However, there couple things which are missing.

1. What is the easiest way to replicate the same for 4 charts? I have charts in my sheet.

2. This does not work immediately. I mean if I select a dimension it does not show the breakdown immediately. It shows only after I select one more dimension. I guess this is because of volume of data. I have my dataset with 10 million records.

Can you think of a method to refresh the chart immediately after pressing the button. (Although it works fine in your example).

Cheers - DV

Dynamic Chart (VB Script)

nagaiank — Sat, 21 May 2011 14:17:13 GMT

Did you consider using cyclic group as dimension? This will help you select any one dimension dynamically.

If you use the same cyclic group in all your four charts,choosing a dimension in one chart will result in choosing the same dimension in other three charts automatically.

Re: Dynamic Chart (VB Script)

kaushiknsolanki — Sat, 21 May 2011 17:06:15 GMT

Hi,

Can you send me the qvw with file and 4 charts which you want.

Yes due to volume of data it may take time.

Regards,

Kaushik Solanki

Re: Dynamic Chart (VB Script)

Wed, 27 Mar 2013 00:59:40 GMT

Dear Kaushik,

I hope you are doing well, This is kumar and i am new to the qlikview,

Kindly help me out with below problem

i have two table 1 and 2 with filed names A, B, i want to create relation b/w fields A and A, then update Table 1 field B with Table 2 Field B Values, Which is same as MS Access update query

Thanks

Kumar

Re: Dynamic Chart (VB Script)

Wed, 27 Mar 2013 00:59:56 GMT

Dear Kaushik,

I hope you are doing well, This is kumar and i am new to the qlikview,

Kindly help me out with below problem

i have two table 1 and 2 with filed names A, B, i want to create relation b/w fields A and A, then update Table 1 field B with Table 2 Field B Values, Which is same as MS Access update query

Thanks

Kumar