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

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

nidheesh — Tue, 01 Oct 2024 10:19:48 GMT

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

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

Tomm — Thu, 17 Oct 2024 08:30:40 GMT

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