topic Re: Counting measures in App Development

Counting measures

agg — Wed, 20 Feb 2019 12:10:37 GMT

Hi,

I'm pretty new with QlikSense and I've been struggling with a pi chart for a few days. Probably it's easy to solve, but I haven't been able to find a proper solution.

Let's assume we have different Incident Families named A, B, C, D and so on. My dimension is Incident Families and my measure is how many incidents belonging to each family have been reported. So I could do a count(). My problem is A, B, C have a similar criteria to count them Count(IdTable = {'14'}, IdItem = {'1','11'})Incidents. However, D have a totally different criteria to count them Count(IdTable = {'19'}, IdDepartment = {'C'})Incidents

I've been trying to solve it by using IF statements, but it doesn't seem to work.

Any suggestion?

Thanks in advance

Re: Counting measures

pradosh_thakur — Wed, 20 Feb 2019 12:34:51 GMT

pick(match(Incidents,'D')+1,Count({<IdTable = {14}, IdItem = {1,11}>}Incidents ),Count({<IdTable = {19}, IdDepartment = {'C'}}>}Incidents ))

Re: Counting measures

pradosh_thakur — Wed, 20 Feb 2019 12:36:26 GMT

Count({<IdTable = {14}, Incidents = {'A','B','C'} ,IdItem = {1,11}>}Incidents )+Count({<IdTable = {19}, Incidents = {'D'}, IdDepartment = {'C'}}>}Incidents )

Re: Counting measures

tresB — Wed, 20 Feb 2019 12:42:01 GMT

Different calculation logic for different dimension members make the expression complex and sometime even not feasible. Expression structure could be like:

If(Match([Incident Families], 'A', 'B', 'C'),
Count({<IdTable={14}, IdItem={1,11}>} Incidents),
Count({<IdTable={19}, IdDepartment={'C'}>} Incidents)
)

Re: Counting measures

agg — Wed, 20 Feb 2019 12:57:51 GMT

Thanks for your reply.

Your solutions is very similar to what I already tried and it doesn't seem to work as it's only one branch of the IF statement (I can't understand why). It counts correctly all families but 'D'. If I change conditions, it counts properly 'D' but not A,B,C, ...

Thanks again for your help.

Re: Counting measures

agg — Wed, 20 Feb 2019 13:34:32 GMT

Thanks for your reply.

It seems to work eventhough I don't get the expected values. I'll check my data to find the mistake.

Thanks!