topic Re: calculated dimension problem in QlikView

calculated dimension problem

viveksairam89 — Tue, 01 Mar 2016 14:24:30 GMT

hi ,

I have requirement I need to display a pie chart based on my selection category and others should group by and should show others in pie chart

For example

LOAD * INLINE [
category, sales
audio, 400
video, 300
a, 200
b, 100
];

if iam choosing audio and video in list box it should reflect in pie chart like audio ,video and

a,b should be others in pie chart it should groupby the sales and should show others in pie chart

like dynamically need to dimension

Regards

vivek

sunny_talwar — Tue, 01 Mar 2016 17:52:27 GMT

Check out the attached:

MarcoWedel — Tue, 01 Mar 2016 23:46:14 GMT

Hi,

another solution could be using a dimension limit like:

=RangeMin(GetPossibleCount(category)+1,FieldValueCount('category'))

hope this helps

regards

Marco

viveksairam89 — Wed, 02 Mar 2016 06:09:55 GMT

Hi,

Thanks Marco and thanks sunny