Expressions, Set Analysis

[Muha]

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.

[Taoufiq_Zarra · Accepted solution]

Maye be :

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

[Muha]

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

[Muha]

Thank you please see attached the excel file.

[Taoufiq_Zarra]

and the goal ?

[Muha]

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) ?

[Muha]

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 · Accepted solution]

@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