Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I display last 30 days, but accumulate from entire data set in a chart

I am tasked with creating some metrics based on currently selected data.

Currently I use an "auto-sizing" dimension variable that changes the chart dimension based on how much data is available.  I am also (thanks to help from here) now able to accumulate proper numbers over time.  I allow the users to select several different fields from list boxes to narrow down what the chart shows.

What I need to do now is shrink the visible window in the chart to the past 30 days, but accumulate over the entire data set so that the last number display is the current total of all issues based on selections.  Below is a copy of my chart, and the dimension I currently use.

Based on experimentation, if I use set analysis in my expression and use the 1, it would appear to invalidate selections made by the user.  I currently use the $ to do analysis based on current selections.

How do I limit my view to 30 days without impacting my accumulated values?

Expression:

Count(DISTINCT  {$<[Target Gate] = {'Alpha - platform'}>} [Master ID])

Dimension:

=if(GetPossibleCount([CreatedDate]) <=36, Date([CreatedDate], 'YYYY-MM-DD'),

    if(GetPossibleCount([Created MonthYear]) <= 36, Date([Created MonthYear],'MMM-YY'),

        [Year]

      )

  )

12 Replies
Not applicable
Author

That definitely cleared quite a few things up.  I never thought to use a text object to vet expressions (was actually looking for a way to do that).

Quite a handy tip.

sunny_talwar

Glad you were able to learn a new trick here today

Best,

Sunny

kaushi2020
Creator II
Creator II

If(Count(DISTINCT {<Date = {"$(='>=' & Date(AddMonths(MonthStart(Max(Date)), -1)) & '<=' & Date(MonthEnd(Max(Date))))"}, MonthYear = >}[Master ID]) > 0,

RangeSum(Above(Count(DISTINCT {<MonthYear = >} [Master ID]), 0, RowNo())))

 

this expression actually helped me for one of the instances. thanks a lot