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: 
Anonymous
Not applicable

how to restrict else part in any condition

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

18 Replies
sunny_talwar

You don't want to show false? May be this:

If(a = 1, true) as emp

Anonymous
Not applicable
Author

Thanks sunny

yeah true but a=0 then? what values we will get using the above condition?

regards,

Bobby

sunny_talwar

Right now you won't get anything, what exactly are you looking for?

Anonymous
Not applicable
Author

please look on the attached file in that i mentioned my details as well

avinashelite

if you don't use the else part null value or indicated as the missing  get populated by default

Kushal_Chawda

Instead IF use set analysis in your expression. This will always give you True

=sum({<A={'1'}>}Value)

Anonymous
Not applicable
Author

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

kkkumar82
Specialist III
Specialist III

Use "Suppress when value is null " in the dimension tab for both the tables you pointed

kkkumar82
Specialist III
Specialist III

This is to eliminate the '-' in the tables, I think this is want you want in the both tables