Null values sorting

[prma7799]

Hi All,

I have one chart in that have null values when i am doing sorting on YTD basis the entire null values come in first row.

I want that entire null values will be place in last row other wise i want to hide null records but my total value don't get effect.

Thanks

[alexandros17]

If your Null values are real Null (and not missing values) you can manage them

- in the script with NullAsValue and NullValue instructions.

- In the chart with the Suppress Null Values CheckBox

[prma7799]

Sir,

My null values is missing values.

PFA i dont want highlighted records but i want that values for total.

[prma7799]

Anyone can help on this

[alexandros17]

In presentation Tab use a value for missing then try to sort

let me know

[prma7799]

not get any impact

[sasiparupudi1]

Change the dimension to a calculated dimension and use an if (MyField='NA','',MyField)

HTH

[prma7799]

Hi Boss,

I using below dimension

=If(Len(Trim([SMNAME])) = 0,'NA',upper(Trim([SMNAME]))& ' '& SM_LEVEL_NAME)

[sasiparupudi1]

may be then

=If(Len(Trim([SMNAME])) = 0,'  ',upper(Trim([SMNAME]))& ' '& SM_LEVEL_NAME)

[qlikviewwizard]

Hi qlikview7799

Can you attach the sample file with data.