Hi,
I do not want to show 0 values from qliksense expression. I have used the below expression.
if(sum(AGGR(sum({<GROUP_CATEGORY={'C:H_Takeover_Investment_Cost'},BUDGET_ACTUAL={'A'},[Report Type Code]={'A'},[%FACT_PERIOD_TYPE]={'MTH'},[ASSET.END_DT]=>} ACTIVITY),[ASSET.ASSET_NAME]))<>0,
sum(AGGR(sum({<GROUP_CATEGORY={'C:H_Takeover_Investment_Cost'},BUDGET_ACTUAL={'A'},[Report Type Code]={'A'},[%FACT_PERIOD_TYPE]={'MTH'},[ASSET.END_DT]=>} ACTIVITY),[ASSET.ASSET_NAME])),'-')
But it seems that the expression is bit heavier. Can you please suggest is there any different way for the same.
Thanks