Null values in expression

[kinjal1645]

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

[PabloTrevisan]

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

[kinjal1645]

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.

[PabloTrevisan]

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

[kinjal1645]

This is fixed

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

[PabloTrevisan]

Hi Kinjal, cool !

Nice job.