Hi!
I'm trying to load alot of expressions into qlikview using Excel but I can't use them since QlikView does not recognize them as expressions.
I found this guide:
http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/
But this doesn't really help me since I have about 30 company IDs which have different expressions for the same KPI.
So my Excel looks a bit like this:
| CompanyID | Expression |
|---|
1 | sum({<account={">=3000<=3999"} >} amount) |
|
| 2 | sum({<account={">=4000<=4999"}>} amount) |
| 3 | | sum({<account={5700}>} amount) |
|
Is there any easy way to import these whole expressions or just the set analysis and use in Qlikview?
