Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlaf_93
Creator II
Creator II

Problem with table

Good morning,

i would like to create a table with three columns like this:

ORDER, TITLE, VALUE,

1, TITLE A, 44,

2, TITLE B, 55,

......;

--> The problem is that i would like to always see all the titles... but they are filtered by the presence of a 'value'. Soo if there isn't one  the title won't be shown.

I tryied with

if(sum(value)<>0, sum(value),0)

but this doesn't work.

 

Thanks.

1 Reply
Qlik1_User1
Specialist
Specialist

Please share the data set sample and expected output