topic Re: to get missing values in a field within the current selection in QlikView

to get missing values in a field within the current selection

Anonymous — Fri, 25 Sep 2015 12:24:58 GMT

Hi,

Is it possible to get missing values in a field within the current selection via the function Concat?

Thank you in advance,

Larisa

Re: to get missing values in a field within the current selection

jonathandienst — Fri, 25 Sep 2015 12:30:30 GMT

I am not sure what you mean. But if you mean can you select null and missing values, the answer is no.

But you can convert null values to a selectable value by using NULLASVALUE fieldname;

There is no way to select genuine missing values. What exactly would you select?

Re: to get missing values in a field within the current selection

Anonymous — Fri, 25 Sep 2015 13:29:07 GMT

For instance all months are selected by default. If a user selects Brand A, then Months Jan and Feb are not active because Brand A has no ads in Feb and Apr.

I want to display a short text info for the end user saying that Brand A has no ads in Feb and Apr. Can I get text values Feb and Apr using a concat funcion?

Re: to get missing values in a field within the current selection

maxgro — Fri, 25 Sep 2015 18:10:54 GMT

maybe

=concat({1 <Months=E(Months)>} DISTINCT Months, ', ')

Re: to get missing values in a field within the current selection

Anonymous — Sat, 26 Sep 2015 11:29:25 GMT

Thank you!