topic Re: Count using set analysis in App Development

Count using set analysis

prahladind9 — Tue, 05 Jul 2016 06:10:00 GMT

Hi,

I need to show the count of customers in qlik sense KPI

To find out the account opened in the last 7 days:

The query which is run on my db is below

select count(a."Customer") from "Casa" a, "DimBranch" b where b."ApplicationDate" >= a."DateTDOpen" AND b."ApplicationDate"- a."DateTDOpen"<=7

result when this query is run on my db >>>14061

set analysis expression used in KPI of sense:

COUNT({$<Customer= {"=ApplicationDate>=DateTDOpen"},

Customer = {"=ApplicationDate-DateTDOpen<=LastXDays"} >} Customer)

query result in qlik sense KPI >>>163

What am i doing wrong ??

migueldelval — Tue, 05 Jul 2016 06:47:26 GMT

Hi Prahlas,

Try this please and tell me

COUNT({$<ApplicationDate={'>=DateTDOpen'},

ApplicationDate={'<=(DateTDOpen-LastXDays'} >} Customer)

Regards

Miguel del Valle

prahladind9 — Tue, 05 Jul 2016 07:00:06 GMT

i tried your query as this:

COUNT({$<ApplicationDate={'>=DateTDOpen'},

ApplicationDate={'<=(DateTDOpen-7)'} >} Customer)

LastXDays is hard coded to 7. The count shows 0

Thu, 07 Jul 2016 04:13:53 GMT

Try this

COUNT({$<ApplicationDate={'>=DateTDOpen <=DateTDOpen+LastXDays'} >} Customer)

It's a bit hard to validate the expression to check if it's correct or not. YOu might just have to check the syntax when copy in.

prahladind9 — Thu, 07 Jul 2016 10:28:36 GMT

I tried your query. The count shows 0