topic Frequency counts of "binary" dimensions in QlikView

Frequency counts of "binary" dimensions

spetushigxpa — Mon, 03 Sep 2018 02:57:05 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
...	...	...	...	...	...	...	...	...	...	...

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: Frequency counts of "binary" dimensions

marcus_sommer — Mon, 03 Sep 2018 12:43:06 GMT

Just transform your data with The Crosstable Load into a "normal" table which will create a dimension-column for your 'Q*' and one Yes/No measure-column and with both you could create your chart whereby the expression might be look like: count({< [measure-column] = {'Yes'}>} [measure-column]).

- Marcus

Re: Frequency counts of "binary" dimensions

Anonymous — Tue, 04 Sep 2018 11:00:03 GMT

Hi Sokol,

Please find the below

Tab1:

CrossTable (Quarter, Status, 2)

LOAD IndexNum,

Reporter,

Q1,

Q2,

Q3,

Q4,

Q5,

FROM

[..\Desktop\Book1.xlsx]

(ooxml, embedded labels, table is Sheet3);

and create a bar chart with Quarter as dimension and Count({<Status={'Yes'}>} Status) as expression. You will get the below result.