Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tommasogaiaspa
Contributor III
Contributor III

filter with set analysis

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

2 Solutions

Accepted Solutions
sunny_talwar

amit_saini
Master III
Master III

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 

 

 

 

View solution in original post

8 Replies
sunny_talwar

amit_saini
Master III
Master III

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 

 

 

 

View solution in original post

tommasogaiaspa
Contributor III
Contributor III
Author

 
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
Contributor III
Contributor III
Author

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

image.png

tommasogaiaspa
Contributor III
Contributor III
Author

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

sunny_talwar

Not based on my understanding

tommasogaiaspa
Contributor III
Contributor III
Author

Ok thanks