Load Fields only if they exist in an expression?

Shu — Tue, 20 Nov 2018 20:27:04 GMT

Hello,

I'm new to QlikSense, so please bear with me. I'm trying to create an expression for a chart that will show the count of a field only for values that are present in another field.

So, for example, let's say I have 2 fields, field1 and field2. Field2 has a lot of empty values but still has data. I have this simple expression for field1, count(distinct[field1]). I'm trying to figure out how to get the count(distinct[field1]) output only when there are values for field2 written in that expression.

Any help is greatly appreciated. Thank you.

Re: Load Fields only if they exist in an expression?

sunny_talwar — Tue, 20 Nov 2018 20:31:00 GMT

May be this

Count(DISTINCT {<field2 = {"*"}>} [field1])

So, the above expression will only count field1 if field2 isn't empty.

topic Re: Load Fields only if they exist in an expression? in QlikView

Load Fields only if they exist in an expression?

Re: Load Fields only if they exist in an expression?