Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bobby_chowdary
Contributor III
Contributor III

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

bobby_chowdary
Contributor III
Contributor III
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?

bobby_chowdary
Contributor III
Contributor III
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

Kush
MVP
MVP

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

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

bobby_chowdary
Contributor III
Contributor III
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