Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Null values sorting

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

Highlighted
Master III
Master III

Re: Null values sorting

Sir,

My null values is missing values.

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

Highlighted
Master III
Master III

Re: Null values sorting

Anyone can help on this

Highlighted

Re: Null values sorting

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

let me know

Highlighted
Master III
Master III

Re: Null values sorting

not get any impact

Highlighted
Master III
Master III

Re: Null values sorting

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

HTH

Highlighted
Master III
Master III

Re: Null values sorting

Hi Boss,

I using below dimension

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

Highlighted
Master III
Master III

Re: Null values sorting

may be then

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

Highlighted
Master II
Master II

Re: Null values sorting

Hi qlikview7799

Can you attach the sample file with data.