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

Set Analysis doesn't work on a field without value

I'm loading data from a database, but I don't know beforehand wich fields will contain values.

Let's say my database contains the equivalent of:

Data:

LOAD * INLINE [

Country, Value, DummyField

DUMMY, DUMMY, DUMMY

];

CONCATENATE (Data)

LOAD * INLINE [

Country, Value

USA, 10

France, 20

Japan, 30

];

If I load all the data:

NewData:

NoConcatenate LOAD *

RESIDENT Data

;

DROP TABLE Data;

And I display a graph:

2012-11-28_194518.png

the Set Analysis "DummyField={'BLABLA'}" works (I don't have data with DummyField equals to "BLABLA").

BUT

If I load only a part of the data, that makes the field "DummyField" always empty:

NewData:

NoConcatenate LOAD *

RESIDENT Data

WHERE Country <> 'DUMMY'

;

DROP TABLE Data;

The same graph displays:

2012-11-28_194941.png

We notice that the Set Analysis "DummyField={'BLABLA'}" doesn't work: I don't have lines with DummyField equals to "BLABLA", but I still have a result.

1 Reply
Not applicable
Author

A workaround is to load every fields one by one with "if(len(my_field) > 0, my_field, 'N/A') AS my_field", but it's a pain in the foot.