Get expressions (or set analysis) from Excel

Tue, 01 Oct 2013 12:23:26 GMT

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:

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

sum({<account={">=3000<=3999"} >} amount)

sum({<account={">=4000<=4999"}>} amount)

sum({<account={5700}>} amount)

Is there any easy way to import these whole expressions or just the set analysis and use in Qlikview?

topic Get expressions (or set analysis) from Excel in QlikView