Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Two-Piece Weekly Volume Averages


I am trying to create a bar graph with weeks on the x-axis and volumes on the Y-Axis. After a certain date (i.e. 30 Oct) there is a massive jump in volume due to some initiative that we are undertaking. I am trying to add additional expressions (i.e. Lines) to the chart that show the massive jump in weekly averages for Pre-30 Oct and another for Post- 30 Oct.

Is there anyway to do this?

2 Replies
Specialist III
Specialist III

You may try adding a vertical reference line for Oct-30, to separate Pre-Oct30 and Post-Oct30.

Not applicable

Didn't know you could do that, so thanks very much for your response.

However, it's not quite what I am looking for. I am building a dashboard that calls out the jump in the average number of weekly sign ups to a website (the time periods are not the same, therefore averages are used to even it out).

I have built an expression that computes the average of the 6 months prior to the reference date, 30 Oct. and the results post 30 Oct. I want these to be horizontal lines on the time series chart so that I can easily show what the stat means.

In fact, I found that adding a Total Column Worked!

Post Oct 30:

= Count(Total {$<LastDayOfWeekSignedUp={"$(= '>' & date(41948))"}>}Distinct CustomerIdentifier) /

     Count(Total {$<LastDayOfWeekSignedUp={"$(= '>' & date(41948))"}>}Distinct LastDayOfWeekSignedUp)

Pre Oct 30:

=Count(Total{$<LastDayOfWeekSignedUp={"$(= '>' & date(BeginSignupMonitoringDate) & '<=' & date(41948))"}>}Distinct CustomerIdentifier)/

Count(Total{$<LastDayOfWeekSignedUp={"$(= '>' & date(BeginSignupMonitoringDate) & '<=' & date(41948))"}>}Distinct LastDayOfWeekSignedUp)