topic Re: filter with set analysis in QlikView

filter with set analysis

tommasogaiaspa — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: filter with set analysis

sunny_talwar — Tue, 18 Jun 2019 11:14:53 GMT

Like this?

Re: filter with set analysis

amit_saini — Tue, 18 Jun 2019 11:29:15 GMT

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,

Re: filter with set analysis

tommasogaiaspa — Tue, 18 Jun 2019 11:37:10 GMT

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

Re: filter with set analysis

tommasogaiaspa — Tue, 18 Jun 2019 11:38:18 GMT

Thanks for the solution.

Re: filter with set analysis

sunny_talwar — Tue, 18 Jun 2019 11:43:50 GMT

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

Re: filter with set analysis

tommasogaiaspa — Tue, 18 Jun 2019 11:58:11 GMT

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

Re: filter with set analysis

sunny_talwar — Tue, 18 Jun 2019 12:13:53 GMT

Not based on my understanding

Re: filter with set analysis

tommasogaiaspa — Tue, 18 Jun 2019 12:35:49 GMT

Ok thanks