Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
quilldew
Creator
Creator

Creating Bar Chart with multiple fields side-by-side with the same options.

Hi there,

I am attempting to create a bar chart that contains data from 5 fields within my main table that all have the same 4 options. I want to count each option listed within the field, performed easily with the count() expression, have this listed as the Legend, and then list the 5 fields and their spread of the options side by side.

I can do this in excel by creating a separate table containing the pivoted fields figures, but I can't for the life of me think of a way to do it in Qlikview. I thought of trying an inline table, or using the Aggr function. As you can probably tell I'm just starting out with Qlikview.

Here is an example of what the chart looks like in Excel. I'd include the counts above the bars.

prevcont.PNG

Many thanks in advance.

1 Solution

Accepted Solutions
quilldew
Creator
Creator
Author

I actually managed to solve this myself.

I used a resident load to copy the column entries into a new table with an extra field that referred to the department. I then just loaded each column into that same table with the same filed names, and then used the department name and option as dimensions and the count of the unique client ID as the expression.

It works very nicely as a count, but I can't now work out how to have each option display as a percentage of the total of the department. I shall get there though.

View solution in original post

3 Replies
Anil_Babu_Samineni

You can create Qlikview as well with the extra metrics for that. If you want to do you need to send that excel file

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
quilldew
Creator
Creator
Author

Okay,

I've attached an example excel file. I'd like to produce a chart that counts the occurence of each option within each field, the bars will represent the % rate at which they occur, and then have the fields listed at the bottom like the picture above shows.

I'm probably not explaining it very well.

Thanks.

quilldew
Creator
Creator
Author

I actually managed to solve this myself.

I used a resident load to copy the column entries into a new table with an extra field that referred to the department. I then just loaded each column into that same table with the same filed names, and then used the department name and option as dimensions and the count of the unique client ID as the expression.

It works very nicely as a count, but I can't now work out how to have each option display as a percentage of the total of the department. I shall get there though.

View solution in original post