topic Re: Function on table in App Development

Function on table

Aika — Wed, 04 Aug 2021 09:41:16 GMT

Hi, I have this table in Qlik Sense:

I would like to have in the table only the Debtors who have all the associated Operations, with Code = 6
so in this case SERVIDIO TERESA, because it has its Operations all with Code = 6, while DI BELLA FRANCESCO no because it has some with Code = 0.
How can it be done?
Using perhaps the function:
Only ([{SetExpression}] [TOTAL [<fld {, fld}>]] expr)
but how exactly?

Thank you...

Re: Function on table

MayilVahanan — Wed, 04 Aug 2021 10:08:22 GMT

Hi Aika,

Try like below

Only({<Debtors ={"=Count(Distinct code)=1 and code=6"}>} code)

Re: Function on table

Aika — Wed, 04 Aug 2021 15:00:49 GMT

Thank you!
One last doubt: if I had to do in a KPI, a count of Debtors returned by the function you suggested:
Only ({<Debtors = {"= Count (Distinct code) = 1 and code = 6"}>} code)

and set the count like this:
Count (Only ({<debtor_name1 = {"= Count (Distinct main_status_code) = 1 and main_status_code = 6"}>} main_status_code))
it gives me an error...

How can I do?

Re: Function on table

MayilVahanan — Wed, 04 Aug 2021 15:25:24 GMT

Try like below

Count ({<debtor_name1 = {"= Count (Distinct main_status_code) = 1 and main_status_code = 6"}>} main_status_code)