topic Re: How to use any formula in load editor dynamically i.e it gets reacted when filters are applied in App Development

How to use any formula in load editor dynamically i.e it gets reacted when filters are applied

aarav021 — Tue, 27 Sep 2022 06:45:16 GMT

I am using a KPI what I need is a performance optimization for that KPI. So there is formula that is being repeated more often so is there way I can set that formula in load editor and use it dynamically in my KPI. Like when using that variable it should change when filters are applied.

Re: How to use any formula in load editor dynamically i.e it gets reacted when filters are applied

rwunderlich — Tue, 27 Sep 2022 07:08:36 GMT

You can create the expression in a variable, for example in script:

SET vSales = Sum(Sales);

And then reference the variable in charts as:

$(vSales)

Note that there is some tweaking that needs to be made in the script if your expression contains $(.

-Rob

Re: How to use any formula in load editor dynamically i.e it gets reacted when filters are applied

aarav021 — Tue, 27 Sep 2022 07:34:02 GMT

It does contain $ ..so what should be done ?

Re: How to use any formula in load editor dynamically i.e it gets reacted when filters are applied

aarav021 — Tue, 27 Sep 2022 07:52:15 GMT

Please help me. I am new to Qliksense

Re: How to use any formula in load editor dynamically i.e it gets reacted when filters are applied

aarav021 — Tue, 27 Sep 2022 08:15:55 GMT

@rwunderlich

Re: How to use any formula in load editor dynamically i.e it gets reacted when filters are applied

BrunPierre — Wed, 28 Sep 2022 01:16:43 GMT

The dollar sign expansion ($); returns the value of the variable instead of its name.

See here: Dollar-sign expansion using a variable

Re: How to use any formula in load editor dynamically i.e it gets reacted when filters are applied

rwunderlich — Thu, 29 Sep 2022 07:12:04 GMT

As an example, let's assume an expression like:

Sum({<Year-{$(=Max(Year))}>}Sales)

If you try script:

SET vSales = Sum({<Year-{$(=Max(Year))}>}Sales);

The script will attempt to evaluate Max(Year) and the variable will be incomplete. Instead, break up the $( in your script like this:

LET vSales = 'Sum({<Year-{' & '$(=Max(Year))}>}Sales)';

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: How to use any formula in load editor dynamically i.e it gets reacted when filters are applied

aarav021 — Thu, 29 Sep 2022 07:35:38 GMT

@rwunderlich @BrunPierre Thank you For helping out. . Thanks much !