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: 
Not applicable

Defining range based on series of values and creating a bar chart based on that

Hi Guys,

I have come across a problem. I have different accounts and each account have multiple contacts.

I want to create a chart which shows the x% of accounts (in Y axis) have contacts in range 1-5, 6-10, etc.(on X axis).

I am attching a excel file with dummy data.

Please help me out.

5 Replies
Not applicable
Author

Hi Rishikesh,

Check the attached QVW for the solution.

Thanks,

Shruthi

nilesh_gangurde
Partner - Specialist
Partner - Specialist

PFA

Hope this will help you

-Nilesh

Not applicable
Author

hi

please check this

hope it helps u

exam.JPG.jpg

Not applicable
Author

Guys..thank you very much for your replies. I really appreciate all of yours solutions, but Shruthi's solution served my purpose the best, Thanks Shruthi and thanks all of you 

Not applicable
Author

Hi Rishikesh,

Please mark the question as answered.