Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

null field

I tried several options but I could not bring field only when it is not null.

Can you help me with the command to be used?

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

In script you can use

where len(fieldName)>0;

or

where not isnull(fieldName);

In chart expression using set analysis

Sum({<FieldName={*}>} FieldName1)

Hope it helps

Celambarasan

Not applicable
Author

continues, the second option that was sent my test, the scrip is that I'm the problem