Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dilipkumard12
New Contributor II

how to restrict measure inside dimension - table - qliksense

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

Tags (3)
2 Replies
dwforest
Valued Contributor

Re: how to restrict measure inside dimension - table - qliksense

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])

dilipkumard12
New Contributor II

Re: how to restrict measure inside dimension - table - qliksense

Dear David,

Thank you for your Reply.

I no need to hide whole row.