Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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