Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible to surpress null value in a textbox?

Hi there, i hope someone can help me with my little problem.

Is is possible, like in the charts, to surpress null value for a dimension in a textbox?

I would like to surpress/remove the pink values in the total sum of the pie chart in the text field.

Thanks
Teis T.W.

1.PNG.png

2.PNG.png

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Try something like

Sum({<Hovedbranche={"*"}>*$} Oms)

View solution in original post

3 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Try something like

Sum({<Hovedbranche={"*"}>*$} Oms)

Not applicable
Author

Many thanks Celambarasan Adhimulan, it Works!

For a side quastion - How does the *$ at the end, work in the set analysis ?

CELAMBARASAN
Partner - Champion
Partner - Champion

It results you the Intersection between the selection($) and the set analysis conditions.

Just it will make the chart to work if any selection made on that field also. If you didn't use that then selection in the field Hovedbranche will be ignored.