topic Re: variables / master Calander in Qlik Answers

variables / master Calander

ddd111rgg23 — Tue, 22 Apr 2025 16:18:29 GMT

hello

i have kpi calculates open depends on some conditions , i used submission year as reference of open mdr on which year that mdr open on , so i want when i filter a specific year it show me open mdr depend on the submission year, bellow my expression that i used:

count(distinct{<MDR_Status = {'Open MDR'},[M.Flag] = {'Material'},SUBMISSION_year = {"<=$(=year(vMAX_CAL_YEAR,'YYYY'))"}>}MDR_NUMBER),

i created variables:

vMAX_CAL_YEAR is =Max(vmdr_year)

my concern when i filter 2025 it show me data , but when i select 2024 there are no data are showing

thank you

Re: variables / master Calander

SRA — Wed, 23 Apr 2025 08:17:11 GMT

Hi,

First of all, 'year' function has only one parameter. You cannot specify the format. This means your 'year' function is not working. Check here for more info :

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/year.htm

You can try something like :

count(distinct{<MDR_Status={'Open MDR'}, [M.Flag]={'Material'}, SUBMISSION_year={"<=$(=vMAX_CAL_YEAR)"}>} MDR_NUMBER)

But, just to be sure, if you select 2025, you want to see all data <= 2025. and if you select 2024 you want to see all data <=2024 (not only 2024). Correct ?

Regards

SRA