topic Changing DIM Fields with Filter in QlikView

Changing DIM Fields with Filter

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

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.

Tahir

swuehl — Tue, 09 Oct 2018 10:13:54 GMT

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

tresB — Tue, 09 Oct 2018 10:16:58 GMT

Create drill-down group in the dimension.

tahirkhalil — Tue, 09 Oct 2018 10:57:23 GMT

Hi,

Thank you - I was playing around with Cyclic Group

Thanks for the tips.

Tahir