Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a list of expression names and formulars that I am importing in from Excel
Expression | Formula |
---|---|
Expression name 1 | formula with set analysis |
Expression name 2 | different formula with set anlysis |
I have then set up my variables such that vExpression = only(Formula).
This allows me to have a drop down list of which variable to pick and means I need less graphs.
Currently, this breaks down if I use set analysis in the formula.
Does anyone know how to over come this?
Mnay thanks,
Isabel
We need to see the Formula
Please paste your formulae here in the discussion.
Is that necessary to give expressions in drop down?
Do your client really need to see the formula you are using?
Check with Whats new in qlikview 11 to use dynamic expressions and dimensions.
From memory, the formulas are like:
Sum({$<[field to exclude]=>} [field to sum])
Now these set analysis formulas work in a table before I copy them into Excel. ( and the purpose of putting them into Excel is so that I have a drop down list of expressions that work in a variable). Now, the variables do work just fine if I take out the set analysis, but if course, I want them in to exclude certain selections!
Please say if this is not enough detail and the I will add in more with formulas/expressions in the morning.
Thanks,
Isabel
Check by removing that $ symbol.
Because qlikview sees the $ symbol and tries to execute it. For the qlikview it is invalid script so it will show error or null.
From memory, the formulas are like:
Sum({$<[field to exclude]=>} [field to sum])
Now these set analysis formulas work in a table before I copy them into Excel. ( and the purpose of putting them into Excel is so that I have a drop down list of expressions that work in a variable). Now, the variables do work just fine if I take out the set analysis, but if course, I want them in to exclude certain selections!
Please say if this is not enough detail and the I will add in more with formulas/expressions in the morning.
Thanks,
Isabel
HI
Try like this
=$(=variableName)
Hope it helps
You may have 2 = signs when you take the formula from Excel do you have it like
=Sum({$<[field to exclude]=>} [field to sum])
and are you then calling the Expression as
=vExpression
This could be the problem
Yes, I believe a drop down is necessary:
I wish to have one graph (it is actually linked to a map with OpenLayers) and let my client select the expression name to plot. They won't see the formula, only the expression name, but my variable is the formula linked to the expression.
There is a possibility that it is my map that will not function with set analysis so I shall test this out first thing.
I will also try the suggestion about removing the $ sign.
Isabel