Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I believe QlikView 11 will solve for this; see "Conditional Enablement of Expressions and Dimensions" in the 11 Beta Release Notes.
Alternatively you can use a macro to enable/disable expression columns. Do some searching in the Community for this and you'll find a good few posts. -Isaiah
Hello.
Another option could be to create separate charts and apply a conditional expresssion in the layout tab that determines which chart is displayed. In my attached exampe, the user can select Chart Type 1, 2 or 3 in the list box. The selection determines which of the 3 pivot charts is displayed.
John.
Hi,
u could use a variable to contain the field to use in the expression.
I have used and it works.
the expression will be:
sum({$< ................ >} $(variable))
Variable will contain a conditional expression to choose correct dimension decided by the user connected...
C u,
Stefano.
You shouldn't need version 11 to conditionally enable expressions, though it depends on your chart type. I think only conditionally enabling dimensions is new in version 11.
In a straight table, go to the presentation tab, and click on "conditional" for the column. Enter the condition associated with the column, which will depend on how you want them to select it. You could have a list box and look for the value being possible, or who knows what else.
see attached for the pivot table expression selector without macros.
Thanks,
Phani
I'm trying to figure out how to use the Conditional enable of expressions in Version 11 but can't find any examples or anything on the forums. The Beta release notes don't have much info yet.?
Anyone used this functionality before?
beanz wrote:
I'm trying to figure out how to use the Conditional enable of expressions in Version 11 but can't find any examples or anything on the forums. The Beta release notes don't have much info yet.?
Anyone used this functionality before?
It's pretty straightforward; similar to the show/hide of columns you could do on a straight table pre-v11. For each expression (and also dimensions) you simply specify an expression that will enable/disable the given column. There are numerous ways you could use this to control which columns show/hide.
Thanks Guys. Why cant we just have the option of a small dropdown in the caption box to open up a list of checkboxes to enable/disable expressions?
Thanks Isiah,
I've created a variable vShowExpressions and used eg:vShowExpression='Peer Group' to conditionally enable each expression.
I've listed variable values in an input box, so that the user can select a value and it's changes the variable.
But it only allows me to select 1 variable value.
Is there any way to make a listbox with the variable, so that the user can select multiple values?