Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

Null values sorting

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

10 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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
Master III
Master III
Author

Sir,

My null values is missing values.

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

prma7799
Master III
Master III
Author

Anyone can help on this

alexandros17
Partner - Champion III
Partner - Champion III

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

let me know

prma7799
Master III
Master III
Author

not get any impact

sasiparupudi1
Master III
Master III

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

HTH

prma7799
Master III
Master III
Author

Hi Boss,

I using below dimension

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

sasiparupudi1
Master III
Master III

may be then

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

qlikviewwizard
Master II
Master II

Hi qlikview7799

Can you attach the sample file with data.