Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

Handling label of labels and sorting of null dimension values

Hello
got a pivot table in which the expression groups results under null (something  correct)
Handling label of labels and sorting of null dimension values

ali_hijazi_0-1700639464308.png
now what I want is to display the row with null value at the end (bottom of the chart) and give it a label Not Submitted
I want primarily to display the record at the bottom so that the cumulative percentage is well displayed
I tried several ways but couldn't reach a solution
Kindly advise

 

I can walk on water when it freezes
Labels (1)
5 Replies
vincent_ardiet_
Specialist
Specialist

Are you creating this dimension in the script? 
If you cannot modify the code, you can try to use coalesce(yourfield,'Not submited') as a dimension.

ali_hijazi
Partner - Master II
Partner - Master II
Author

Hello Vincent
didn't work
you mean I use the coalesce function in the Dimensions on the chart no?

I can walk on water when it freezes
vincent_ardiet_
Specialist
Specialist

Yes.
But it depends of your datamodel or the expression your are using. Could you modify the loading script? If this is the case, this is better to replace the NULL value there.

anat
Master
Master

Try to handle null values in backend

Else use calculated dimension like 

If(isnull(field) or trim(Len(field)) =0, 'Not Assigned', field) 

ali_hijazi
Partner - Master II
Partner - Master II
Author

The null values come from the result of the expression used

Which contains a union n the set analysis (count expression)

So part of the result comes under the brackets, and the remaining are classified as nulls

Both approaches suggested above (calculated dimension / coalesce) not working

I can walk on water when it freezes