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
Highlighted

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

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

Anyone can help on this

Highlighted

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

let me know

Master III
Master III

not get any impact

Highlighted
Master III
Master III

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

HTH

Highlighted
Master III
Master III

Hi Boss,

I using below dimension

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

Highlighted
Master III
Master III

may be then

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

Highlighted
Master II
Master II

Hi qlikview7799

Can you attach the sample file with data.