Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Three dimensions but only show one of the three if 1 of 3 selections is made

I have a dimension  [Division] that contains only two items, 'Spa' and 'Bath'

In a new field, When 'Spa' is selected i want to display the dimension [Elec Comp], when 'Bath' is selected i want to display the dimension [Packaging]

when neither 'Bath' or 'Spa' is selected i want the new field to to be null()

[Division]

Spa

Bath

[Elec Comp]

[Packaging]

1 Solution

Accepted Solutions
Not applicable
Author

Hello Joseph,

I would create a calculated dim (e.g. in a straight table) like this

=if(GetFieldSelections([Division]) = 'Spa', [Elec Comp],

    if(GetFieldSelections([Division]) = 'Bath', [Packaging])

    )

Regards, Roland

View solution in original post

2 Replies
Not applicable
Author

Hello Joseph,

I would create a calculated dim (e.g. in a straight table) like this

=if(GetFieldSelections([Division]) = 'Spa', [Elec Comp],

    if(GetFieldSelections([Division]) = 'Bath', [Packaging])

    )

Regards, Roland

Not applicable
Author

Roland,

i created a calcualted dim based on your suggestions and i was ale to get exactly what i needed. 

Thank you for your help.