Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

live data versa compared historic using average counts


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 !


1 Reply
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:


or set analysis:



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


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.