Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master
Master

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

Highlighted
Master
Master

@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
Highlighted
Master
Master

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

Highlighted
Contributor II
Contributor II

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.

Highlighted
Master
Master

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") 😉
Highlighted
Contributor II
Contributor II

Thank you please see attached the excel file.

Highlighted
Master
Master

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") 😉
Highlighted
Contributor II
Contributor II

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

Highlighted
Master
Master

=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") 😉
Highlighted
Contributor II
Contributor II

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.

Highlighted
Master
Master

@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