WTD,MTD & YTD info irrespective of filter selection

[Anonymous]

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?

[JustinDallas]

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]

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 ?

[Anonymous]

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

[Anonymous]

I have not created any flag

How to get this done without a flag?

[YoussefBelloum]

Ok, my question was not clear enough maybe.

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

[Anonymous]

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]

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_AMT	Date
120	01/01/2017
95	01/02/2017

[Anonymous]

Yes i have....

Its called as Process Date

[YoussefBelloum]

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