Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Grouped Bar Chart for a single column data

Hello.

I'm new to QlikView, but since I've read a lot of the manual and still can't do what I need, I had nowhere else to ask.

My question has 2 steps:

1) I have a column filled with A's, B's and C's, and I want a bar chart of their frequencies: a single bar that shows the proportion between those three factors. (A grouped bar chart for the column)

2) I actually have 10 columns like that, and I want a panel that shows one bars like the one described above for each column.

Is it possible? What dimensions and what expressions should I write for that?

English is not my mother tongue, I'm sorry for the mistakes I probably made.

Thank you in advance for your attention.

Labels (1)
2 Replies
jwjackso
Specialist III
Specialist III

!Using this data:

Data:

LOAD * Inline [

Dept,Prod,Units

D1,A,10

D1,B,5,

D1,C,5,

D2,A,8,

D2,B,1,

D2,C,1

];

Dimensions are Dept,Prod

Expression is =Sum(Units)/Sum(Total <Dept>Units)

StackedBarChart.PNG

Anonymous
Not applicable
Author

Actually, I can't group them like that because I need to be able to cross data between the columns.

My data looks like:

ID, item1, item2, item3

1, A, A, B

2, B, A, B

3, A, C, B

4, C, C, A

5, A, C, C

6, B, A, C

7, B, C, B

And I need to be able to filter between those columns, i.e.: "how does Item2 distributes among the ID's (rows) that have A in the column Item1?"