Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am not a hundred percent if I am doing the following correctly:
I am trying to set a measure expression to show that if no selection is made, default value selection is set to High Risk, if other selection is made, the the KPI updates to selected risk.
Can anyone assist?
Thank you !
hi
it should be something like
if(getselectedcount(RISK_FIELD)=0, sum(IF(RISK_FIELD='high risk',Value)),sum(Value))
Thank you very much for your reply.
Here is my measure expression, but it is giving me a syntax error. where am I going wrong?
if(getselectedcount(ListItemsFromID_Riskdescription)=0, sum(IF(ListItemsFromID_FullImpact='High',Value)),sum(Value))
Details:
Chart type: Treemap
Dimension: ListItemsFromID_Riskdescription
Measure: if(getselectedcount(ListItemsFromID_Riskdescription)=0, sum(IF(ListItemsFromID_FullImpact='High',Value)),sum(Value))
hi
i just checked on similar expression syntax and it's working ,
so it's something specific to your syntax , i don't see anything wrong
can you post sample data
here is a snapshot of the data, and an extract of the data file