Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

suryajegan
Contributor

WTD,MTD & YTD info irrespective of filter selection

Hi, I have a KPI tiles which should show the Weekly ,Monthly & Yearly irrespective of the global filter selection Where i have used this set analysis formula in order to get the Rolled_to_Amt value. Formula: Sum({}[ROLLED_TO_AMT]) I am looking to add a default selector(Weekly ,Monthly & Yearly) control in the same set analysis. Can anyone please help?

17 Replies
JustinDallas
Valued Contributor II

Re: WTD,MTD & YTD info irrespective of filter selection

Hmm, I'm not terribly sure off the top of my head.  I would start with something like this.

SUM( {1<MTD={1}>} InvoiceCharges )

The '1' before the alligator mouth tells Qlik that we want to look over the whole data set and where we have the property MTD set as a flag in our datamodel.

YoussefBelloum
Esteemed Contributor

Re: WTD,MTD & YTD info irrespective of filter selection

Hi,

it will work only if he have flags on his tables.

otherwise, he will need to use fields like: Date field, Month and Year fields, MMYYYY or YYYYMM fields.. all this inside a set analysis.

So what do you have exactly on your model ?

suryajegan
Contributor

Re: WTD,MTD & YTD info irrespective of filter selection

I dont have any Date filters in the set. something like this =Sum({}[Weekly_Rollover_Activity_Only.ROLLED_TO_AMT])/1000000 I wants to add the date condition inside this set

suryajegan
Contributor

Re: WTD,MTD & YTD info irrespective of filter selection

I have not created any flag

How to get this done without a flag?

YoussefBelloum
Esteemed Contributor

Re: WTD,MTD & YTD info irrespective of filter selection

Ok, my question was not clear enough maybe.

I want to know what is the Date fields you have on your model

suryajegan
Contributor

Re: WTD,MTD & YTD info irrespective of filter selection

LET vDateStart = Timestamp(YearStart(Today()), 'YYYY-MM-DD hh:mm:ss.fff');

LET vDateEnd  = Timestamp(YearEnd(Today()), 'YYYY-MM-DD hh:mm:ss.fff');

This wt i have created in the model. In order to pull the current year info.

Are you looking for this or something else?

Sorryyyyy

YoussefBelloum
Esteemed Contributor

Re: WTD,MTD & YTD info irrespective of filter selection

No problem, I'm not looking for this.

if you want to make YTD/MTD etc it is time related analysis, so you should at least have a Date field on your model.

like this:

ROLLED_TO_AMTDate
12001/01/2017
9501/02/2017
suryajegan
Contributor

Re: WTD,MTD & YTD info irrespective of filter selection

Yes i have....

Its called as Process Date

YoussefBelloum
Esteemed Contributor

Re: WTD,MTD & YTD info irrespective of filter selection

and did you create a master calendar using this field Process_date ?

Community Browser