how to restrict else part in any condition

[Anonymous]

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

[Anonymous]

kkkumar82 thanks

nope ,think little bit advance i dont want use any options  to supress null values in tables..

i want to control the "-" in column level

Regards,

Bob

[kkkumar82]

You mean to say you dont want to hide the column values rather you don't want see the '-'  then

goto presentation tab-> clear missing symbol , null symbol text boxes

Hope it may help you

[Anonymous]

hI avinashelite

Can you provide  any QVW  file or i need some more information about your words

Regards,

Bobs

[florentina_doga]

in dimension try this

=if(len(DATE_with_noProgress)<>0,DATE_with_noProgress,'none')

[avinashelite]

try this expression in the text box , and let me know your inputs .

if(1=0,1)

//since the condition is not satisfied it will search for the else part and we have not written it ..so check what output you will get 

[Anonymous]

Hay Avinash R , haa haa

Hay yeah true above condition good but the conditions is not seems my original condition

please check my QVW earlier i attached

regards,

bob

[avinashelite]

currently I don't have the QV license so i will be not able to open the file ...please post the expression your using with sample data and desired output so that it will be helpful me to understand the requirement

[Anonymous]

Hi Avinash R,

thanks for giving reply

please see attached sceen shot

in above image in "Date2" Columns i am getting Date and "_" .so now my aim is  i want to restrict the "_" values in Column creation level or variable level

means when  i am creating the column that time i need to hide or delete or restrict the "_" values or may be in variable is it possible

date(if(total=0,[Date]),'MM/DD/YYYY')

date(if(total<>0,[Date]),'MM/DD/YYYY')

here when i am using this code i am getting "_" in column level so i want to restrict that one.i dont want to use any conditions in charts or pivots or some other charts

regards,

bobb

[avinashelite]

I got your problem now , see in TABLE2 you have values for Country , Date etc so your condition is working fine but since other values are present it populating the missing value in that place ..

try like this

TABLE2:

LOAD country,

Date as Date2

total

resident

TABLE1

where total<>0;

this will eliminate the missing values