Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
viveksairam89
Creator
Creator

calculated dimension problem

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

1 Solution

Accepted Solutions
MarcoWedel

Hi,

another solution could be using a dimension limit like:

QlikCommunity_Thread_207635_Pic1.JPG

QlikCommunity_Thread_207635_Pic2.JPG

QlikCommunity_Thread_207635_Pic3.JPG

QlikCommunity_Thread_207635_Pic4.JPG

QlikCommunity_Thread_207635_Pic6.JPG

QlikCommunity_Thread_207635_Pic5.JPG

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

hope this helps

regards

Marco

View solution in original post

3 Replies
sunny_talwar

Check out the attached:

Capture.PNG

MarcoWedel

Hi,

another solution could be using a dimension limit like:

QlikCommunity_Thread_207635_Pic1.JPG

QlikCommunity_Thread_207635_Pic2.JPG

QlikCommunity_Thread_207635_Pic3.JPG

QlikCommunity_Thread_207635_Pic4.JPG

QlikCommunity_Thread_207635_Pic6.JPG

QlikCommunity_Thread_207635_Pic5.JPG

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

hope this helps

regards

Marco

viveksairam89
Creator
Creator
Author

Hi,

Thanks Marco and thanks sunny