Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Null values in expression

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

stalwar1swuehlgwassenaartresescojagan

5 Replies
Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

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.

Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

This is fixed

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

Highlighted
Partner
Partner

Hi Kinjal, cool !

Nice job.