How to change the dimensions in charts on the fly?

[#1]

I want to present the user a custom list of dimensions and allow them to 'cut' the data in several charts using the dimension (e.g. product, region, etc.). I have used $field but many of the things aren't dimensions but measures as well. I want a subset of the field list. I'd also really like to change the measure on the fly as well if it's possible in a similar way.

Hope the idea is clear from the description. 🙂

[#2 · Accepted solution]

You can do this using QlikView's built in Groups for both Dimensions and Expressions. A Cyclical Dimension would allow the user to quickly change dimensions. The same can be done with a Group of Expressions.

There are also more complicated ways of doing it, like using a variable for the expression and changing the value of the variable to different expressions based on what the user would like to see. If Groups are sufficient for your needs, they are probable the better way of doing it.

[johnw]

Well, it isn't clear to me. But in case this is anywhere near what you're asking for, see attached.

Edit: If dimension and expression groups will serve the need, that's a far more robust approach than what I posted.

[#4]

EDIT

After 40 minutes of trying different ways to assign and receive the values between a button and a chart, I've got it working. This is now pretty much what I wanted.

Thanks to you both for input. Great community.