Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Manage null values in a Table

Hi All.

I'm starting from here:

comm1.png

Now I have to insert the description for each measure and i'd ike to create 3 new columns.

I'm trying to do that using if condition but the result is:

comm2.png

How can i create my new column filling the same row instead of generating 3?

What is the correct statement in this case?

Excluding null value clicking on the specific flag box , the result is an empty tabale.

Thank's a lot.

3 Replies
Highlighted
MVP
MVP

I think this might work for you as as expressions:

=Only( {<%Tp_dato={6}>} #um )

=Only( {<%Tp_dato={5}>} #um )

=Only( {<%Tp_dato={10}>} #um )

Highlighted
MVP
MVP

or this:

=Concat(DISTINCT  {<%Tp_dato={6}>} #um )

=Concat(DISTINCT {<%Tp_dato={5}>} #um )

=Concat(DISTINCT {<%Tp_dato={10}>} #um )

Highlighted
Specialist II
Specialist II

Hi,

what is #um ?

there's no agregate operator, just if that'w why null for other rows

add maxString before if,

or maybe only if there is only one #um

regards