topic Chart with parameter as expression in QlikView

Chart with parameter as expression

Thu, 23 Dec 2010 19:03:14 GMT

Hi all

I'd like to create a dynamic Bar Chart with this constraints :

An user can choose a variable in a listBox and the Chart displays the result for this variable as an expression.

To achieve this I have a table with n variables V1 to Vn and some dimensions

I have also a table of infomation for each variable

My objective is to create a bar chart using :

- the Label information as a title;

- the denominator as a part of my expression . Example = Sum(V1)/Sum(V5)

Is it possible to achieve this in a straighforward way ?

Regards and merry Xmas

Jean-Jacques

Thu, 23 Dec 2010 19:17:58 GMT

Are they making a selection on Variable? If so, you should be able to use Only().

Label:

=Only(Label)

Expression:

Sum($(=Only(Variable)))/Sum($(=Only(Denominator)))

I think you need the dollar sign expansion in the Sums to avoid nested aggregates.

Thu, 23 Dec 2010 20:45:28 GMT

Well done Ninja !

Exactly what I need. You are right the dollar sign expansion is needed

Thanks for your time