Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

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

Hi Rishikesh,

Check the attached QVW for the solution.

Thanks,

Shruthi

nilesh_gangurde
Valued Contributor

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

PFA

Hope this will help you

-Nilesh

Not applicable

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

hi

please check this

hope it helps u

exam.JPG.jpg

Not applicable

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

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

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

Hi Rishikesh,

Please mark the question as answered.

Community Browser