Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Restrict the filter

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.

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Re: Restrict the filter

12 Replies
Highlighted
Creator II
Creator II

Re: Restrict the filter

You can apply filter while loading the data

Highlighted
Specialist
Specialist

Re: Restrict the filter

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

Highlighted
Creator
Creator

Re: Restrict the filter

Hi Pratysuh,

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

Can you please tell me the option using set variable

Highlighted
Specialist
Specialist

Re: Restrict the filter

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

Regards
Pratyush

Highlighted
Creator
Creator

Re: Restrict the filter

hi ,

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

Highlighted
Specialist
Specialist

Re: Restrict the filter

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

Regards
Pratyush

Highlighted
Specialist
Specialist

Re: Restrict the filter

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

Highlighted
Creator
Creator

Re: Restrict the filter

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

Highlighted
Creator
Creator

Re: Restrict the filter

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