Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

filter and table

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

tablerz.PNG

1 Solution

Accepted Solutions
souadouert
Specialist
Specialist
Author

thank y sunny

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

View solution in original post

5 Replies
sunny_talwar

When you select Zone, Region gets selected automatically?

souadouert
Specialist
Specialist
Author

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

sunny_talwar

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

souadouert
Specialist
Specialist
Author

the opossite  all the zone that fall under a region

souadouert
Specialist
Specialist
Author

thank y sunny

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