topic Re: Using a Field from exel as an expression in App Development

Using a Field from exel as an expression

Wolfee — Wed, 23 Mar 2022 19:32:55 GMT

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 "=-"

Re: Using a Field from exel as an expression

Or — Wed, 23 Mar 2022 19:44:14 GMT

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?

Re: Using a Field from exel as an expression

marcus_sommer — Thu, 24 Mar 2022 14:43:46 GMT

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

Re: Using a Field from exel as an expression

Wolfee — Thu, 24 Mar 2022 16:53:33 GMT

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