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: 
tahirkhalil
Creator
Creator

Changing DIM Fields with Filter

HI All,

I have a requirement, I need to change the DIM value according to the selection.

I have hierarchy in data for Zone, Region and City - Now by default my dimension will be

a) Zone

if I select/Click any Zone Bars from the chart - the dimensions will change to

b) Region (related to specific/clicked Zone)

Once I select some specific Region - the dimension should change to

c) City (related to that clicked Region)

See attached test doc with data populated.

Thanks for your help.

R,

Tahir

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe use a drill-down dimension group (create from the groups button on dimension tab or document properties).

View solution in original post

3 Replies
swuehl
MVP
MVP

Maybe use a drill-down dimension group (create from the groups button on dimension tab or document properties).

tresesco
MVP
MVP

Create drill-down group in the dimension.

Capture.JPG

tahirkhalil
Creator
Creator
Author

Hi,

Thank you - I was playing around with Cyclic Group

Thanks for the tips.

Tahir