Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
fhana
Contributor II
Contributor II

Subscription to a dashboard with dynamic date ranges

Hi,

I have an application with ticket stats data spread across a few sheets.
I want to create two subscriptions to the same set of sheets, one with a date range of the previous month and the second with a date range of the previous quarter.

How can this be achieved in general so the date is dynamic and Is there a way to achieve this without duplicating the app to get two different dynamic date ranges?


Labels (1)
1 Reply
fhana
Contributor II
Contributor II
Author

I found a way to approach this and most charts work well beside one based on a particular measure. 

Here is what I did
I created two dimensions and two filters based on these dimensions then selected each filter and created separate subscriptions.
First thing I don't understand is that the filters show values -1 and 0 when -1 is selected the filter is active and charts are adjusted to proper values.

Dimensions
Last Month
=([sd.created] >= MonthStart(AddMonths(Today(), -1)) AND [sd.created] <=
MonthEnd(AddMonths(Today(), -1)))

Last Quarter 
=[sd.created] >= QuarterStart(AddMonths(Today(), -3)) AND [sd.created] <= QuarterEnd(AddMonths(Today(), -3))

Second thing I don't understand is that one measure doesn't follow the conditions or I'm missing something.

The measure expression is
count(distinct{<resolved = {">=$(=Min(sd.created)) <=$(=Max(sd.created))"},[sd.created]= >} key)

seems like the [sd.created]= is not taken in to consideration cause this measure 
count(distinct{<resolved = {">=$(=Min(sd.created)) <=$(=Max(sd.created))"} >} key)

shows exactly the same amount and I know there should be more based on SQL's that I run on the source.

When I ignore all the filters with 1 like this 
count(distinct{1<resolved = {">=$(=Min(sd.created)) <=$(=Max(sd.created))"},[sd.created]= >} key)

it starts to work