topic Re: Creating a table with list of Count(field) in Visualization and Usability

Creating a table with list of Count(field)

Tue, 11 Oct 2016 10:45:16 GMT

Hi - I'm very new to Qlik Sense.

My data are a set of employee answers to general feedback questions. I used typeform to collect the data, and it is generally stored one of three ways in the resulting .csv file

a) a column representing a number or metric e.g. "How happy are you on a scale of 1-10"

b) a column representing a single text answer e.g. "Do you like cats OR dogs" or "Pick your favourite from this list of animals"

c) a column representing an answer to a multiple choice e.g. "Pick as many of this list as you like" and the columns would be "Dogs" "Cats" "Mice" etc.

I am having trouble with columns of type C). I would like to create a table that lists the count of responses for these multiple choice answers.

Basically I would like

Count(peoplewholikeCats)

Count(peoplewholikeDogs)

Count(peoplewholikeMice)

I have tried to create a table, but Count(RespondentIdentifier) as a dimension and measures of Count(peoplewholikeCats) doesnt work - it tells me the dimension is invalid.

Does this question make sense? :s

Re: Creating a table with list of Count(field)

shraddha_g — Fri, 14 Oct 2016 09:09:47 GMT

Aggregation function doesn't work in Dimension.

You can calculate count(RespondentIdentifier) at Load Script and then try using that field in chart as dimension.

I hope it is helpful.

Re: Creating a table with list of Count(field)

sunny_talwar — Fri, 14 Oct 2016 11:06:23 GMT

I think what you need is to create a table like this

Dimensions

Type C

Measure

Count([Type C])

Re: Creating a table with list of Count(field)

swuehl — Fri, 14 Oct 2016 11:22:48 GMT

You can transform your crosstable like input table into a straight table, using

The Crosstable Load‌

CROSSTABLE (Choices, Answer)

LOAD

AnswerID, Dogs, Cats, Mice

FROM YourInputTable;

This would transform your columns into two fields, Choices and Answer.

Use Choices as dimension field and do a count valid answers.