Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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