Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

adding,subtracting,dividing and multiplying dimensions at the script level

hi all,

I want to know whether we can perform these functions on the two dimensions at the backend or not.

for example

in my fact table i have three columns amount,tax,rent .

the expression i am using at the UI level is sum({$< yearcode={'P'}>} amonut}+ sum({$< yearcode={'P'}>} tax}+sum({$< yearcode={'P'}>} rent}

i want to use it with dimnesion like

sum({$< yearcode={'P'}>} amonut1}

where amount1= amount+rent+tax.....

Is this possible at the script level??? and similar way other functions can be performed or not???

1 Reply
whiteline
Master II
Master II

Hi

Yes of course, its possible.

No. You cann't use set analysis in script.

when you load your data just add another field:

LOAD

     ...

     rangesum(amount, tax,rent) as amount1

     ...

FROM ...