filter with set analysis

[tommasogaiaspa]

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

[sunny_talwar · Accepted solution]

Like this?

[amit_saini · Accepted solution]

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 

[tommasogaiaspa]

Yes perfect thanks.
I ask for another help if it is possible to represent the table as shown in the attached image, where the NIobb field is not displayed on all lines but is a union.
I enclose an image to better understand.
Thank you

[tommasogaiaspa]

Thanks for the solution.

[sunny_talwar]

This can happen, but then the NIobb expression will be a dimension and will be placed right next to Obiettivo... something like this

[tommasogaiaspa]

Ok understood. So in the expression fields is it not possible to have it joined?

[sunny_talwar]

Not based on my understanding

[tommasogaiaspa]

Ok thanks