Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Specialist III
Specialist III

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
Champion
Champion

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
Not applicable
Author

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
Not applicable
Author

I have not created any flag

How to get this done without a flag?

YoussefBelloum
Champion
Champion

Ok, my question was not clear enough maybe.

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

Anonymous
Not applicable
Author

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
Champion
Champion

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
Anonymous
Not applicable
Author

Yes i have....

Its called as Process Date

YoussefBelloum
Champion
Champion

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