Using a Field from exel as an expression

[Wolfee]

I am trying to bring a Column from excel that contains qlik expressions to use in a KPI. Example: Column Row F2 "  'Count(Ids) " 

Loaded into qlik as KPI Calc. I have got it to work intermittently using =($=[KPI Calc]) evaluating as "=Count(Ids)", but it will also break and be evaluated as "=-"

[Or]

Have a look at https://community.qlik.com/t5/Qlik-Design-Blog/The-Magic-of-Variables/ba-p/1465499 for a clear and concise explanation of how the dollar sign expansion works for variables containing formulas.

Without knowing what context breaks it, it's hard to guess what the issue might be. Possibly a selection is excluding the value of this column, or resulting in more than one row being returned for this column?

[marcus_sommer · Accepted solution]

Within a KPI you could use something like this:

$(=only({< [KPI Name] = {'Count ID'}>} [KPI Calc]))

It will only work if there is only a single KPI-expression possible - either through a selection or with a set analysis like above. You couldn't apply this logic to several [KPI Calc] within a chart/table - if you want to do something like this you would need a pick(match()) approach.

Qlik doesn't support an evaluate() within the UI and the above showed bypass-logic are technically possible but practically rather unhandy and adding often more complexity and efforts as benefits.

- Marcus

[Wolfee]

This solution works, but I have noticed it will appear to fail due to a seemingly random filter of KPI calc being applied.