Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

amien
Valued Contributor

Re: If statement in calculated dimension breaks the selection

yes!

Its basicly the samen solution. The NorthWind solution give order in the Dimension selections using a treeView. i want the same thing, but the with separate listboxes (which i can put in a container).

Re: If statement in calculated dimension breaks the selection

I think you'll have to combine it with this technique of using alternate states then: Using Alternate States to Select Multiple Values in a List Box with Different Attributes

kuba_michalik
Contributor III

Re: If statement in calculated dimension breaks the selection

Not necessarily impossible.

You could write a macro that would remove all dimensions from the table, then add them back in order specified in the data, with the proper show/hide conditions referring to an appropriate data island, based on value of the Tag field.

This would not be a user-facing macro - only the developer would have to run it when the dimension sort order was changed, so most of the usual caveats about using macros in Qlikview would not apply. If you don't have a specific requirement about rearranging the dimensions by updating e.g. a spreadsheet, without any developer input, then this could be a pretty maintainable solution. But then again, I'm not sure how well would a table with 700 dimensions work, even if 99% of them were conditionally disabled :/

kuba_michalik
Contributor III

Re: If statement in calculated dimension breaks the selection

And here's my third and (I think) final brilliant idea

Summary: data islands, use set analysis to merge selections in data islands into a selection on the main Field field

Highlighted
amien
Valued Contributor

Re: If statement in calculated dimension breaks the selection

@Jakub .. that is indeed brilliant

Thanks