topic Re: filter and table in QlikView

filter and table

souadouert — Wed, 12 Apr 2017 10:46:24 GMT

I have a region table(table Region ) containing several zone(table Zone ), and I need to display a table (measure = realization / objective) by zone and by region, the problem when I select the zone, the region measure just take the line of the zone selected, how can to eliminate the filter in the region measurement

Re: filter and table

sunny_talwar — Wed, 12 Apr 2017 10:58:03 GMT

When you select Zone, Region gets selected automatically?

Re: filter and table

souadouert — Wed, 12 Apr 2017 10:59:56 GMT

No , first i have to select region after that Zone, because in the regions one finds the zones

Re: filter and table

sunny_talwar — Wed, 12 Apr 2017 11:01:24 GMT

So although you have selected a single region, you want to see all the regions that fall under a zone? May be set analysis like this

{<Region, Zone = p(Zone)>}

Re: filter and table

souadouert — Wed, 12 Apr 2017 12:46:11 GMT

the opossite all the zone that fall under a region

Re: filter and table

souadouert — Wed, 12 Apr 2017 12:57:19 GMT

thank y sunny

{<Zone, Region = p(Region)>}