null value handling in table box i

[Anonymous]

i have feild desc contain two values high and low and another feild bucket like time range.

i want to produce table high feild and low feild with bucket.

write condition if(desc='high','time range')

if(desc='low','timerange')

it display the values and nulls also are displaying but i didnt need.

i want to dispaly time and no null values lean and peak.please provide me any logic

[PrashantSangle]

Hi,

Sorry,I did not get what are you trying to say. Can you elaborate "rest of fields will not displaying"

Regards,

[balabhaskarqlik]

Better, post your script & Expressions here. What are the fields you're seeing and what else fields you're not able to see?

[manoj217]

If you want to replace something with null means

if(isnull(field, replacevalue, field))

[balabhaskarqlik]

In UI, on defining two expressions, it's checking for auto join / value comparisons, so where values not equal it's showing Null values.