Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
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

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.