Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Sir,
My null values is missing values.
PFA i dont want highlighted records but i want that values for total.
Anyone can help on this
In presentation Tab use a value for missing then try to sort
let me know
not get any impact
Change the dimension to a calculated dimension and use an if (MyField='NA','',MyField)
HTH
Hi Boss,
I using below dimension
=If(Len(Trim([SMNAME])) = 0,'NA',upper(Trim([SMNAME]))& ' '& SM_LEVEL_NAME)
may be then
=If(Len(Trim([SMNAME])) = 0,' ',upper(Trim([SMNAME]))& ' '& SM_LEVEL_NAME)
Hi qlikview7799
Can you attach the sample file with data.