Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Trellis chart - how to forcibly display all segments?

Hi,

my question is largely in the title:

- I have successfully made a combochart with data from an Excel sheet into a Trellis_chart with four segments

<=> For this week (the standard_selection is the_last_week on a Monday and the current_week from Tuesday on), there is data only
       for one of the four dimension_data_points which my Trellis_option is based upon
     => With the standard_selection, only one of the four segments is displayed which looks a bit weird.

=> Is there a way to forcibly display all segments of a Trellis_chart, even if there is no data for the current selection?

Thanks a lot!

Best regards,

DataNibbler

4 Replies
christian77
Partner - Specialist
Partner - Specialist

Hi.

Try, if(is null(expression),0,expression).

Show ceros.

Salutes.

datanibbler
Champion
Champion
Author

Hi Chris,

the first thing you suggest is like a Dummy_formula, yes? I've tried that in both ways, by

     - putting this IF_construct in the actual expression

     - creating an additional Dummy_expression that can always be displayed (no conditions)

<=> Unfortunately, that doesn't work yet.

=> Which "show zero values" do you mean? I've tried several. No success yet.

Thanks a lot!

Best regards,

DataNibbler

datanibbler
Champion
Champion
Author

Hi,

this seems to work now 😉

I noticed there was something wrong in the loading script: In a series of LOADs and RESIDENT LOADs I had there, the data seems to have been concatenated erroneously. I introduced an explicit naming of the table_to_concatenate_to, now it seems fine.

Best regards,

DataNibbler

christian77
Partner - Specialist
Partner - Specialist

Hi.

There is a checkbox on Presentation tab that Suppresses Zero Values. Sometimes is convenient not to have that checked.

Chris.