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 😕