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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
spetushigxpa
Contributor
Contributor

Visualize Frequency Counts of Binary Dimensions

Hello,

I have multiple dimensions in each record with either a 'Yes' or a 'No' value and would like to display a frequency count when 'Yes' appears against a dimensions.

Example:

IndexNumReporterQ1Q2Q3Q4Q5Q6...Qn-1Qn
0001reporter AYesNoYesNoYesYes...NoNo
0002reporter BNoYesYesYesYesYes...YesYes
0003reporter BNoNoYesYesNoYes...NoYes
0004reporter CYesNoNoNoYesYes...NoYes
0010reporter AN/AYesNoN/ANoYesN/AYes
...Header 8

I would like to show a horizontal bar chart, where the x-axis has the dimensions: Q1 to Qn and the y-axis shows the counts of 'Yes' against each dimension. some kind of histogram of 'Yes' counts against the corresponding dimensions.

Thank you

Sokol

5 Replies
marcus_sommer

Please do not double-posting: Frequency counts of "binary" dimensions

spetushigxpa
Contributor
Contributor
Author

Thought this would be relevant to both forums.

Can I include more than one forum when I post a question?

marcus_sommer

The most forums are not really separated from each other unless a few language- or profession specific ones. I think the intention by creating them was different but now they are just a kind of categorise. This means in the most cases it's not useful to repeat the posting in various forums and should there be a good reason (maybe within a language specific groupand in the general area) then it would be helpful to add in each one a link to other posting.

- Marcus

spetushigxpa
Contributor
Contributor
Author

Got it, thank you for the clarification. Should I remove this one?

marcus_sommer

I think it's not necessary.