topic Re: Calculated dimension in QlikView

Calculated dimension

shanky1907 — Wed, 14 Sep 2016 11:42:11 GMT

Hello All,

i have to implement one requirement like when one of the dimension value is selected from filter then the chart should show values expression values according to that selection and the remaining data should be represented as 'Others' for rest of the values of the dimension.

Can anybody help regarding this issue. It will be great help.

Re: Calculated dimension

miguelbraga — Wed, 14 Sep 2016 11:53:49 GMT

Hey there,

You make by going to Dimension Limits and in Values add this expression:

=GetSelectedCount(FieldName)

Show me what you've got

Regards,

Re: Calculated dimension

shanky1907 — Wed, 14 Sep 2016 12:05:38 GMT

Hello Miguel,

Thanks for your response. Actually i am using a pivot chart where dimension limit is no option.

And my requirement is like if there is dimension like name and values as 'A', 'B', 'C' ...

Then if i select A from filter then the chart should show values for A and rest for all values it should show as others as the dimension value.

Please revert if you are getting me or not.

Re: Calculated dimension

sunny_talwar — Wed, 14 Sep 2016 12:17:59 GMT

May be you can use an approach similar to what has been specified here:

Re: Can I add an additional row to a Straigh Table to display a subtotal value?