Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
divya_anand
Creator III
Creator III

Show respective expression values irrespective of selection made

Hi,

I am trying to create a straight table with the following dimension & Expression

Dimension

=if (match(Field_Character,'xyz') and match(Field2,'abc'), Code_No)

Expression

num#(interval(below(Date) - Date,'ss'))
-
if(Field2='abc',cycle)

The problem is that - since I am using Below() function, when I select 1 value in dimension, the expression value is displaying "-". How do I freeze it to show the respective values in spite of making a selection. But, when I make the selection, only that Dimension value should be displayed.

Any ideas?

Thank you.

5 Replies
sunny_talwar

Try this

Num#(Interval(below(Only({<Code_No, Field_Character, Field2>} Date)) - Date,'ss'))
-
if(Field2='abc',cycle)

divya_anand
Creator III
Creator III
Author

Hi Sunny,

Thank you for your response. This works, however, it shows "-" for all other Code_No in the table when I make a selection. Is it possible to show only the selected Code? Not sure if this is a possibility since I am using Below() function.

sunny_talwar

‌can you make sure that ‘Suppress Zero Value’ is checked on the presentation tab of the chart properties?

divya_anand
Creator III
Creator III
Author

Sunny,

But that would also not display the Codes where the difference in time is actually 0, when I do not make any selection, right?

sunny_talwar

In that case I would suggest you to look into using The As-Of Table