Measure with if and when 2 dimensions equate

abonnery — Sat, 16 Nov 2024 16:51:59 GMT

Dear Qlik Experts.

I am struggling with creating a measure where 2 fields are equals.

What I am trying to do is to have the 3rd field below not null.

I am trying to sum all measures [EAC -FA] where the dimension [Cost Baseline version - FA] (2nd image) is equal to the dimension below (2nd field in the 1st image and this code works):

only({<[Year - FA]={2020}>} if([Month - FA]<>1 and [Month - FA]<>12, if([Month - FA]<=10,'RF_'&[Year - FA]&'_0'& Num([Month - FA]-1),'RF_'&[Year - FA]& '_' & Num([Month - FA]-1)),'.'))

As you can see below, I have tried to make this new measure work (3rd field) with this code without any success :

Aggr(sum(if([Cost Baseline Version - FA]= Aggr(only({<[Year - FA]={2020}>} if([Month - FA]<>1 and [Month - FA]<>12, if([Month - FA]<=10,'RF_'&[Year - FA]&'_0'& Num([Month - FA]-1), 'RF_'&[Year - FA]& '_' & Num([Month - FA]-1)), '.')) ,[Month - FA]) ,[EAC - FA]/1000000)),[Month - FA])

Do you wee why the last code isn't working ? The syntax of the 2 fields I am trying to equate is EXACTLY the same. Maybe I need to add a # somewhere ?

I have not tried it with a set analytics because I don't know how to do it with a "simple" if function.

Thank you very much for your help. I have been stuck for days on this.

topic Measure with if and when 2 dimensions equate in App Development

Measure with if and when 2 dimensions equate