Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
nidheesh
Contributor III
Contributor III

Current Year or Current Quarter or Current Month is that configurable to specific date from the source instated of the default date capturing

Current Year or Current Quarter or Current Month is that configurable to specific date from the source instated of the default date capturing,

Description:  While trying a question in Insitz advisor Claim Count Processed During Current Year

Current year not pointing to Processed Date ,  it pointed to Entry Date instead of processed date

for pointing that into processed date - have created vocabulary for processed date as processed during and then tried question Claim Count Processed During Current Year.

 

So can we make it configuring eg: Q: Claim Count Processed During Current Year using processed during current year or month then it need's to be captured based on the processed date and also if we are trying Claim Count received during current year or month then it need's to be captured based on the received date

nidheesh_0-1727777390864.png

nidheesh_1-1727777441934.png

 

 

Labels (1)
1 Reply
Tomm
Contributor III
Contributor III

If I'm understanding correctly you need could use an autocalendar (You can find an example by searching 'Qlik Sense Autocalendar') to index each date field against current date (today())

Here is an example that work out the different between any date (in any field) and todays date and store it into a new field.

Insert below into your load script.

 

 

[autoCalendar]:
DECLARE FIELD DEFINITION Tagged ('$date')
FIELDS
    ((year(Monthstart(Today()))*12)+month(Monthstart(Today()))) - (((year($1)*12)+month($1))) as [Month_Index]
        ;
DERIVE FIELDS FROM EXPLICIT TAGS ('$date','$timestamp') USING autoCalendar;

 

 


Once you have your indexes then setup your measures using the appropriate index in set analysis like

Count ({<Processed_Date.Month_Index ={0}>} Value) with 0 representing current month