Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

live data versa compared historic using average counts

Hi

I have a live feed every ten mins which gives me counts of patients admitted so far, and I have this split various ways.

But I have another feed which consists of the 4 weeks worth of admissions, and the previous years same period  to be used for comparison etc.

so I want to basically have a count so far today - which I have

then a count (average) for the last 4 previous Wednesdays ( if Wednesday is today)

and a count of last years' 4 previous Wednesdays etc.

I was just going to put theses in text objects as number comparisons, and then again into pivots, so show more detail /drill

 

how am I best going about this -I cant even get an average count 😞

my today so far on dataset 1 = =Count(UnitNumber)

I have this by hour also: with a dimension = hour(admissionDate)

 

Thanks !

liz

1 Reply
Highlighted
Digital Support
Digital Support

Re: live data versa compared historic using average counts

The only two ways of which I can think to go at this are something like the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

or set analysis:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

This will kick things back up as well, not sure if someone else may have better ideas or not...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.