topic Re: Null values sorting in QlikView

Null values sorting

prma7799 — Wed, 22 Jul 2015 09:12:59 GMT

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 — Wed, 22 Jul 2015 09:24:57 GMT

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 — Wed, 22 Jul 2015 09:55:11 GMT

Sir,

My null values is missing values.

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

prma7799 — Wed, 22 Jul 2015 10:06:06 GMT

Anyone can help on this

alexandros17 — Wed, 22 Jul 2015 10:09:52 GMT

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

let me know

prma7799 — Wed, 22 Jul 2015 10:18:26 GMT

not get any impact

sasiparupudi1 — Wed, 22 Jul 2015 10:19:18 GMT

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

HTH

prma7799 — Wed, 22 Jul 2015 11:03:16 GMT

Hi Boss,

I using below dimension

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

sasiparupudi1 — Wed, 22 Jul 2015 11:13:55 GMT

may be then

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

qlikviewwizard — Wed, 22 Jul 2015 11:15:38 GMT

Can you attach the sample file with data.

qlikviewwizard — Wed, 22 Jul 2015 11:16:11 GMT

Sample file will help us in giving solution quickly. Thank you.