topic Re: Display a running total in QlikView

Display a running total

rittermd — Sat, 24 Jan 2015 15:29:49 GMT

Here is my challenge. I am relatively new to Qlikview.

I have data that contains rows for a member for a particular type of service. So a member could have 1 row for single service or could have multiple rows for many services.

Based on some criteria a service could be overdue and we want to notify them of that.

In my dashboard table I need to show the number of their services that are overdue on each row in the table. So if they have 5 services and 3 are overdue I need to show 3 on each of the 5 rows in the table for that member.

I am not sure how to do this or if I can do this.

Thanks for any guidance.

Re: Display a running total

francoiscave — Sat, 24 Jan 2015 15:56:17 GMT

Hi Mark,

Can you send us a sample app.

It will be easier to help you.

Thanks,

François

Re: Display a running total

rittermd — Sat, 24 Jan 2015 16:25:20 GMT

I really can not as the data is health care related.

Re: Display a running total

MarcoWedel — Sat, 24 Jan 2015 16:59:56 GMT

Hi,

you can scramble your data before uploading:

http://community.qlik.com/docs/DOC-1290

Hope this helps

Regards

Marco

Re: Display a running total

Anonymous — Sat, 24 Jan 2015 17:01:45 GMT

Hello,

in a straight table with Member and Service as dimensions, you can use the following expression:

sum(total <Member > Aggr(count({<Overdue={'y'}>} Service),Member ))

where Overdue is the field that indicates if the service is ovredue (y) or not (n).

Let me know.

KR,

Elena

Re: Display a running total

Anonymous — Sat, 24 Jan 2015 17:13:29 GMT

Hi Mark,

Do age analysis:

Create buckets using interval function:

If((interval(Date(Today(),'DD-MM-YYYY hh:mm:ss')-Date(Date/Time,'DD-MM-YYYY hh:mm:ss'),'dd'))<=30, 'P1',
If((interval(Date(Today(),'DD-MM-YYYY hh:mm:ss')-Date(Date/Time,'DD-MM-YYYY hh:mm:ss'),'dd'))<=60, 'P2',
If((interval(Date(Today(),'DD-MM-YYYY hh:mm:ss')-Date(Date/Time,'DD-MM-YYYY hh:mm:ss'),'dd'))<=90, 'P3','Overdue'))) as ByAge,

Expression:

Count({<ByAge = {'Overdue'}>}Service)

Regards

Neetha