Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deep2021
Creator III
Creator III

Removing 0 values from qliksense expressions

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

0 Replies