topic Re: Restrict the filter in QlikView

Restrict the filter

kvr9 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Restrict the filter

Anonymous — Wed, 08 Nov 2017 11:36:47 GMT

You can apply filter while loading the data

Re: Restrict the filter

prat1507 — Wed, 08 Nov 2017 12:08:15 GMT

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

Re: Restrict the filter

kvr9 — Fri, 10 Nov 2017 08:44:47 GMT

Hi Pratysuh,

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

Can you please tell me the option using set variable

Re: Restrict the filter

prat1507 — Fri, 10 Nov 2017 09:58:06 GMT

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

Regards
Pratyush

Re: Restrict the filter

kvr9 — Fri, 10 Nov 2017 10:08:19 GMT

hi ,

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

Re: Restrict the filter

prat1507 — Fri, 10 Nov 2017 10:16:00 GMT

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

Regards
Pratyush

Re: Restrict the filter

prat1507 — Fri, 10 Nov 2017 10:17:39 GMT

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

Re: Restrict the filter

kvr9 — Fri, 10 Nov 2017 10:18:03 GMT

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

Re: Restrict the filter

kvr9 — Fri, 10 Nov 2017 10:23:35 GMT

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

Re: Restrict the filter

prat1507 — Fri, 10 Nov 2017 10:36:14 GMT

Are you using the given expression in a listbox?? Listbox shows only distinct Values.

Regards

Pratyush

Re: Restrict the filter

kvr9 — Fri, 10 Nov 2017 11:10:51 GMT

Yes

Re: Restrict the filter

kvr9 — Mon, 13 Nov 2017 16:45:11 GMT

Hi ,

Can I use variable to solve this issue?