Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
i have one dought in m mind can we restrict else part in any condition
ex:
if(a=1,ture,false) as emp
now here i want to restrict false values in emp column. i want to display condition satisfy values(ture)
i mean in if statement i want to restrict the else
Reagrds,
Bobby
You don't want to show false? May be this:
If(a = 1, true) as emp
Thanks sunny
yeah true but a=0 then? what values we will get using the above condition?
regards,
Bobby
Right now you won't get anything, what exactly are you looking for?
please look on the attached file in that i mentioned my details as well
if you don't use the else part null value or indicated as the missing get populated by default
Instead IF use set analysis in your expression. This will always give you True
=sum({<A={'1'}>}Value)
hi kaushal,
=sum({<A={'1'}>}Value) --this one will give the metric values ..like i need similar way
for ex:
A=0
A=1
A=2
=sum({<A={'1'}>}a)--i need like this is it possible?
regards,
Brahma
Use "Suppress when value is null " in the dimension tab for both the tables you pointed
This is to eliminate the '-' in the tables, I think this is want you want in the both tables