Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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.