Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need to create several tables, one for each target size (a table that contains the data of objective A01 and so on with the others), as shown in the table of the attached qvw file.
I think I need to use the set analysis, but I tried several attempts but I couldn't.
Can someone help me.
thank you
Hello ,
You need to add below code on your variable.
For A01:
sum({<Obiettivo={'A01'}>}(Effettivo-[Range Min])*100)/([Range Max]-[Range Min])
sum({<Obiettivo={'A01'}>}TOTAL <Obiettivo>(Effettivo-[Range Min])*100*[Peso Indicatore]/([Range Max]-[Range Min]))
Similarly , you need to create different variable for A02, A03 and so on and call those variable in respective table.
Second , option is to use IF condition in your dimension like below:
=if(Obiettivo='A01',Obiettivo)
Similarly, so for other tables.
Hope this helps!
Regards,
AS
Like this?
Hello ,
You need to add below code on your variable.
For A01:
sum({<Obiettivo={'A01'}>}(Effettivo-[Range Min])*100)/([Range Max]-[Range Min])
sum({<Obiettivo={'A01'}>}TOTAL <Obiettivo>(Effettivo-[Range Min])*100*[Peso Indicatore]/([Range Max]-[Range Min]))
Similarly , you need to create different variable for A02, A03 and so on and call those variable in respective table.
Second , option is to use IF condition in your dimension like below:
=if(Obiettivo='A01',Obiettivo)
Similarly, so for other tables.
Hope this helps!
Regards,
AS
This can happen, but then the NIobb expression will be a dimension and will be placed right next to Obiettivo... something like this
Ok understood. So in the expression fields is it not possible to have it joined?
Not based on my understanding
Ok thanks