how to restrict measure inside dimension - table - qliksense

[Anonymous]

I have an requirement of restrict measure if completed is 100% then dimensions should show blank.

[dwforest]

That would require each dimension to be an If() statement and a measure since you are conditioning it on a measure:

If(Sum(need)/sum(done)=1, dimension,'')

What you posssibly want to do is only show rows that are incomplete?

Add a measure with set expression - Only({$<[key field]={"=Sum(need)/sum(done)=1"}>} [key field])

[Anonymous]

Dear David,

Thank you for your Reply.

I no need to hide whole row.