Restrict the filter

[kvr9]

Hello,

I need some help on filters.

My data model contains 35 countries  and has two different values such as Sales and spends all countries have Sales but only few countries have spends data.So when I enter into the Spend related data sheet the country with spends should be active and other countries should be grated out.

I tired triggers like Onactive Spend >=0 and it works for me but it is populating in Current selection filed and if try to clear it all countries are active again.

Could some one help me to resolve it.

[Anonymous]

You can apply filter while loading the data

[prat1507]

=if(aggr(Count({<Spends -= {"=IsNull(Spends)","=len(Spends)=0"}>} DISTINCT Country),Country)>0,Country) 

[kvr9]

Hi Pratysuh,

Could you please tell me where can i use this expression.

Can you please tell me the option using set variable

[prat1507]

Add a listbox. and add an expression as the above to get all the Countries as per your requirement.

Regards
Pratyush

[kvr9]

hi ,

I can see the result as below,I just want to see only one line and inactive country in grey

[prat1507]

do you want all the countries or only those where Spend>=0?

Regards
Pratyush

[prat1507]

Go into the presentation tab and enable the Single column option.

[kvr9]

1st I want spends>0 and if possible all countries where spend related countries active and other as inactive

[kvr9]

My issue is not showing in single column but the data I can see Austria two times.

I just want to see it one time