Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You should be able to do it using Group by clause
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.