Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Hi Jagan,
Thanks a lot.
Works perfect for me.
Cheers,
Kenneth