Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using set analysis within a variable (and the variable is an expression imported from Excel)

Hi all,

I have a list of expression names and formulars that I am importing in from Excel

ExpressionFormula
Expression name 1formula with set analysis
Expression name 2different 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

11 Replies
Not applicable
Author

Hi Allan,

That was a good idea, but I don't have the = in the Excel Formula so sadly this isn't the solution!

Thanks though!

Isabel

Not applicable
Author

The issue appears to be with the OpenLayers extension not accepting the set analysis, not infact the variable which work.

I shall open up a new discusison to see if anyone knows how to get around that!

Isabel