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: 
bdunphy
Contributor III
Contributor III

Optional Expressions?

Hi,

I have a pivot table  with 3 expressions.
1) FCast/Actual
2) Prior Year
3) Budget
However not all users need to see all 3 expressions  at all times. Sometimes they will only want to see the FCast/Actual - other  times they would like to see two expressions.

Is it possible to  allow the user to decide what expresssions he/she wants to see?

e.g. only show the  FCast/Actual initially and then allow then to select to see the Budget and Prior  year too if necessary

If its not possible at the moment - is it something that is planned in version 11?
Thanks
16 Replies
isaiah82
Creator III
Creator III

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

john_duffy
Partner - Creator III
Partner - Creator III

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.

Not applicable

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.

johnw
Champion III
Champion III

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.

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

see attached for the pivot table expression selector without macros.

Thanks,

Phani

Not applicable

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?

isaiah82
Creator III
Creator III

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.

ExpressionCondition v11.png

bdunphy
Contributor III
Contributor III
Author

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?

Not applicable

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?