topic Re: Null values in expression in QlikView

Null values in expression

kinjal1645 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a chart with columns team, t_id, parameter1, parameter2,....,paramter5.

I have a list box with following expression:

=aggr(Only({1<

parameter1=p(parameter1),

parameter2=p(parameter2),

parameter3=p(parameter3),

paramete4=p(parameter4),

parameter5=p(parameter5)

>} team & '\' & t_id), t_id)

When you click on any t_id in the chart, this list box will display t_id that has same combination of paramerter1, parameter2..parameter5 as selected t_id.

But the list box displays blank when any parameter in selected t_id is null.

How do I handle null values with the expression?

Thanks,

Kinjal

stalwar1‌swuehl‌gwassenaar‌tresesco‌jagan

Re: Null values in expression

PabloTrevisan — Tue, 17 Jul 2018 18:51:56 GMT

You can go into Add-ons - Data manipulation and create a calculation condition to display result only when the value is other than null.

Or create a comparison to return 'No combination' forcing a return .. I do not know if this is what you are looking for

Re: Null values in expression

kinjal1645 — Tue, 17 Jul 2018 19:10:26 GMT

I want to display values in the list box as per the expression mentioned.

But listbox is not populating any values when any parameter is a null value.

Re: Null values in expression

PabloTrevisan — Tue, 17 Jul 2018 21:21:05 GMT

Now I get it ... Can you send me a small qvf? I believe it is an error in the expression

Re: Null values in expression

kinjal1645 — Wed, 18 Jul 2018 21:08:48 GMT

This is fixed

Used if(len(trim(parameter))>0,..) with above expression

Re: Null values in expression

PabloTrevisan — Wed, 18 Jul 2018 21:29:51 GMT

Hi Kinjal, cool !

Nice job.