DYNAMIC FORMULE QLIK SENSE

jmialoundama — Sat, 16 Nov 2024 19:40:12 GMT

Hello,

I have a problem with a formula that I want to make dynamic.

I have the following PivotTable and I put a pane that points to my dimension called "CODE". This filter allows the user to choose the code he wants to analyze in the crosstab.

SUM (BALANCE_M.VALUE OF N) - SUM (BALANCE.VALUE M) - SUM (BALANCE_M.CODE SELECTED) + SUM (SELECT BALANCE_Y.CODE)

My formula is:

= Sum ({<CODE = {'681740'}>} [BAI_BALANCE_M]) - sum ({<CODE = {'781740'}>} [BAI_BALANCE_M]) - sum ({<CODE = {'397000'}>} [BAI_BALANCE_M]) + sum ({<{CODE = '397000'}>} [BAI_BALANCE_DEC_Y_1])

This formula is fixed, I wish that this formula is dynamic, that is to say that when the user has like code N = 1234, M = 45742, and CODE = 67940 then the formula automatically changes alone in the table.

Thanks in advance

Re: DYNAMIC FORMULE QLIK SENSE

Anil_Babu_Samineni — Fri, 15 Nov 2019 11:12:29 GMT

How is the values are calculating?

topic Re: DYNAMIC FORMULE QLIK SENSE in App Development

DYNAMIC FORMULE QLIK SENSE

Re: DYNAMIC FORMULE QLIK SENSE