topic Re: Qilksense: Count with consideration on multiple columns in QlikView

Qilksense: Count with consideration on multiple columns

wuming79 — Thu, 25 Oct 2018 08:54:42 GMT

Hi,

I have the following table below:

I want to make a table that shows as below:

Month	Total Fruits that is Class 2 and 4
JUN	3

lironbaram — Thu, 25 Oct 2018 08:58:08 GMT

you can use

count({<Class={"2,4"}>}distinct Fruits)

Anil_Babu_Samineni — Thu, 25 Oct 2018 09:04:42 GMT

Try this, If this is in script

Table:

Load * From Table;

Final:

Load Month, Count(Fruits) as [Total Fruits that is 2 and 4] Resident Table Where Match(Class, 2,4) Group By Month;

If Design, you may try like below?

count({<Class={"2,4"}>} Fruits)

Count(If(Match(Class, '2','4'), Fruits))

wuming79 — Thu, 25 Oct 2018 09:06:16 GMT

I got invalid dimension

Anonymous — Thu, 25 Oct 2018 11:09:37 GMT

Add it as a measure

wuming79 — Fri, 26 Oct 2018 02:53:14 GMT

I got it working now. Thanks!