topic Re: Visualize Frequency Counts of Binary Dimensions in QlikView

Visualize Frequency Counts of Binary Dimensions

spetushigxpa — Mon, 03 Sep 2018 02:47:22 GMT

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:

IndexNum	Reporter	Q1	Q2	Q3	Q4	Q5	Q6	...	Qn-1	Qn
0001	reporter A	Yes	No	Yes	No	Yes	Yes	...	No	No
0002	reporter B	No	Yes	Yes	Yes	Yes	Yes	...	Yes	Yes
0003	reporter B	No	No	Yes	Yes	No	Yes	...	No	Yes
0004	reporter C	Yes	No	No	No	Yes	Yes	...	No	Yes
0010	reporter A	N/A	Yes	No	N/A	No	Yes		N/A	Yes
...	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

Re: Visualize Frequency Counts of Binary Dimensions

marcus_sommer — Mon, 03 Sep 2018 12:45:20 GMT

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

Re: Visualize Frequency Counts of Binary Dimensions

spetushigxpa — Mon, 03 Sep 2018 19:32:56 GMT

Thought this would be relevant to both forums.

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

Re: Visualize Frequency Counts of Binary Dimensions

marcus_sommer — Tue, 04 Sep 2018 05:40:41 GMT

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

Re: Visualize Frequency Counts of Binary Dimensions

spetushigxpa — Fri, 07 Sep 2018 04:24:15 GMT

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

Re: Visualize Frequency Counts of Binary Dimensions

marcus_sommer — Fri, 07 Sep 2018 05:09:17 GMT

I think it's not necessary.