Variable as measure (hiding column in Qlik Sense Table)

[guyvermeiren]

Hello,

I want to hide columns in Qlik Sense by using defined variables in the measure.

The measure I use is:

= Sum( {$<[COPA.Fiscal Year]= {$(=max([Calendar.Year]))} , [COPA.Period]= {"*"}, >}  [COPA. Budget Gross Sales] ) /1000

I made a variable called "Plan" with the same formula.

See the result I get when using the measure and the variable in the same table in attachment.

Using the formula ==> result OK by Period ==> Measure = Sum( {$<[COPA.Fiscal Year]= {$(=max([Calendar.Year]))} ,

[COPA.Period]= {"*"}, >}  [COPA. Budget Gross Sales] ) /1000

Using variable in measure ==> always the total by period ==> Measure =[Plan]

What is wrong ?

Thanks,

Guy

[sunny_talwar · Accepted solution]

When storing the expression in the variable.... store it without the equal sign...

=Sum( {$<[COPA.Fiscal Year]= {$(=max([Calendar.Year]))} , [COPA.Period]= {"*"}>}  [COPA. Budget Gross Sales] ) /1000