topic set analysis expression in back end in QlikView

set analysis expression in back end

dandaanilreddy — Wed, 25 Nov 2020 16:16:04 GMT

Hello Qlik Experts

Is there any way i can create the below expressions in back end. i have 30 set analysis expressions in the front end i want to create the expressions in the backend script so that i can use it as a field in the front end charts. Please let me know.

sum({$<Desc={'A50+Accounts'}>}value)/Rangeavg(Below(Total sum({$<Desc={'Charge'}>}value),1,3)

Sum({$<name={'ABC'}>}value/Above(sum({$<name={'ABC'}>}value),1)

RangeAvg(Above(sum({$<Desc={'Abc'}>}value),1,12))/RangeAvg(Above(sum({$<Desc={'EFG'}>}value),1,12))

Thanks

Anil

Re: set analysis expression in back end

sunny_talwar — Wed, 30 Aug 2017 14:39:47 GMT

You should be able to do it using Group by clause

Re: set analysis expression in back end

edmondo_tassi — Fri, 08 Sep 2017 15:02:13 GMT

I don't sure to understand your request, but below and above are graphics functions. Replicate Above function in script

The core is: make a key for the correct layer of your calculation, then order resident table, and then partialize the result of your calculation in script.

Of course you have to use where and group by clause. The result must to take in count of all dimensione of your analysis.