Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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