topic Variable in QlikView

Variable

upaliwije — Thu, 04 Feb 2021 07:13:44 GMT

I have following Pivot Table

Column 1 has the following expression

sum({$<PERIODID = {$(=Max(PERIODID))},YEAR =,QUARTER =,MONTH =,PERIOD =,RC_R_TYPE={'DIRECT','FT'}>}RC_AMOUNT)

Column2 has the following expression

sum({$<PERIODID = {$(=Max(PERIODID))},YEAR =,QUARTER =,MONTH =,PERIOD =>}$(vTsale))

My variable

$( vTsale)=sum({<RC_R_TYPE={'DIRECT','FT'}>}RC_AMOUNT)

My Column 2 does not show any value. Can you please help me to correct my Column 2 Expression

edwin — Tue, 09 Feb 2021 16:14:09 GMT

try this:

sum({$<PERIODID = {$(=Max(PERIODID))},RC_R_TYPE={'DIRECT','FT'},YEAR =,QUARTER =,MONTH =,PERIOD =>}RC_AMOUNT)

edwin — Tue, 09 Feb 2021 16:15:15 GMT

the problem is, depending on how the variable is defined it could be doing this:

sum({$<PERIODID = {$(=Max(PERIODID))},YEAR =,QUARTER =,MONTH =,PERIOD =>}sum({<RC_R_TYPE={'DIRECT','FT'}>}RC_AMOUNT))

which will not make sense to QV

edwin — Tue, 09 Feb 2021 16:17:40 GMT

now looking at your screenshot (bec its hard to read bec its very small and smudged) that may be what is being resolved as