Counting

[#1]

Hi,

I know this isn't much of a challenge but I'm still new to Qlik Sense. So here we go.

I have this kind of data:

I like to produce tables which show me the numbers of each type of animal per farm_type. Like this:

Any suggestions how to script/calculate this ?

Thanks in advance.

[jagan · Accepted solution]

Hi,

Try like this

Data:

LOAD

ID,

Farm_Type,

Animal_1  AS Animal,

Number_1 AS Number

FROM DataSource;

Concatenate(Data)

LOAD

ID,

Farm_Type,

Animal_2  AS Animal,

Number_2 AS Number

FROM DataSource;

Now you can use Farm_Type and Animal as dimensions and Sum(Number) AS Expression.

Hope this helps you.

Regards,

Jagan.

[#3]

Hi Jagan,

Thanks a lot.

Works perfect for me.

Cheers,

Kenneth