Only Show Data for Months with Data

cbaqir — Wed, 02 Dec 2015 20:55:07 GMT

I have a chart that shows a monthly accuracy %.

Dimension: =if(today()>FISCAL_YEAR_MONTH,FISCAL_YEAR_MONTH)

Expression: $(vForecastVariance) = num((($(vForecastRound)-$(vActualRound))/($(vForecastRound))), '#,##0.0%')

Variable: vActualRound = round(sum({$}ACT_AMT), 1000)/1000

I only want the data to show where sum($(vActualRound)))>0 so that if we don't have actuals posted for the current month, no % will show for that month.

My expression is set to show condtional: aggr(sum($(vActualRound)))>0, FISCAL_MONTH_YEAR) but this doesn't seem to be working because even though we don't have anything in ACT_AMT for November, I still see a % for November.

Any thoughts?

Thanks,

Cassandra

Re: Only Show Data for Months with Data

Wed, 02 Dec 2015 21:04:21 GMT

You can write Calculated Dimension like below:

IF(AGGR( Sum(ACT_AMT) , FISCAL_YEAR_MONTH )>0,FISCAL_YEAR_MONTH)

Or change Your expression:

IF( $(vActualRound) > 0 , num((($(vForecastRound)-$(vActualRound))/($(vForecastRound))), '#,##0.0%') )

topic Re: Only Show Data for Months with Data in QlikView

Only Show Data for Months with Data

Re: Only Show Data for Months with Data