Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Muha
Contributor II
Contributor II

Expressions, Set Analysis

Hello,

Is there any set analysis I can use to show for example I have a bar chart. I want to show a particular region for a particular year. For example showing Europe overweight for 2015? Secondly the set analysis =count ({<Sex={'MLE'}>} My Indictaor), how do I add year also to it.

Many thanks in advance.

2 Solutions

Accepted Solutions
Taoufiq_Zarra

Maye be :

=count ({<Sex={'MLE'},YEAR={2015}>} My Indictaor)

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

Taoufiq_Zarra

@Muha 

I'm not sure if I understood correctly.
Is that what you mean?

for example to filtre country Afghanistan :

Dimension :

=if(Country='Afghanistan',Country)

and unselect include null value

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

10 Replies
Taoufiq_Zarra

Maye be :

=count ({<Sex={'MLE'},YEAR={2015}>} My Indictaor)

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Muha
Contributor II
Contributor II
Author

Thank you so much Taoufiq, it works...you are the best. One more  thing please. Can you help me with another set analysis to sort in table like the attached below. I want to show for a particular country, region and income status.

Taoufiq_Zarra

can you share a sample data or give me more details

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Muha
Contributor II
Contributor II
Author

Thank you please see attached the excel file.

Taoufiq_Zarra

and the goal ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Muha
Contributor II
Contributor II
Author

I want to filter by country with set analysis or expression without using a filter pane. Thank you

Taoufiq_Zarra

=count ({<Sex={'MLE'},YEAR={2015},Country={'THECOUNTRY'}>} My Indictaor) ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Muha
Contributor II
Contributor II
Author

Sorry for bothering you. It a standalone table, its not connected to the rest of my data. I just want to filter by countries instead of using the filter pane. please  see attached , I took a screenshot of the table.

Taoufiq_Zarra

@Muha 

I'm not sure if I understood correctly.
Is that what you mean?

for example to filtre country Afghanistan :

Dimension :

=if(Country='Afghanistan',Country)

and unselect include null value

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉