topic Need selected field value in combo chart in QlikView

Need selected field value in combo chart

Wed, 09 May 2012 06:54:03 GMT

Hello All,

I am having some issue, using combo chart.My requirement is,i am having 4 list box in front-end it is parent -child hierarchy.

i am using combo chart and pivot table,i want to display only the value for selected field.

But i am using this expression,

=sum({<year = {'$(V_YEARMAX)'},month = {'$(V_MONTHMAX)'}>} ParameterValue)

it is displaying total value.

ex:- when i am selecting second dimension,it is displaying total value for second, third and fourth dimensions.my requirement is to display only selected field value.

any-one know the solution for this issue.

regards,

baru

Need selected field value in combo chart

nilesh_gangurde — Wed, 09 May 2012 07:24:28 GMT

Hi Baru,

Use the Cyclic dimension which will show values for single dimension which you will select.

Create the cyclic group for the fields which you want to add as a dimension.

Regards,

Nilesh Gangurde

Need selected field value in combo chart

Wed, 09 May 2012 08:30:22 GMT

Hi,

thanks for your reply,

I am not taking all dimensions,i am using only one dimension.

which is showing in combo chart.

regards,

baru

Need selected field value in combo chart

Wed, 09 May 2012 09:19:51 GMT

For the year and month in the variable and for the current selections you need right.

Try this code:

=sum({$<year = {'$(V_YEARMAX)'},month = {'$(V_MONTHMAX)'}>} ParameterValue)