topic Re: Show respective expression values irrespective of selection made in QlikView

Show respective expression values irrespective of selection made

divya_anand — Thu, 29 Mar 2018 05:38:33 GMT

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.

Re: Show respective expression values irrespective of selection made

sunny_talwar — Thu, 29 Mar 2018 09:04:10 GMT

Try this

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

Re: Show respective expression values irrespective of selection made

divya_anand — Thu, 29 Mar 2018 10:42:37 GMT

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.

Re: Show respective expression values irrespective of selection made

sunny_talwar — Thu, 29 Mar 2018 10:45:33 GMT

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

Re: Show respective expression values irrespective of selection made

divya_anand — Thu, 29 Mar 2018 10:49:16 GMT

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?

Re: Show respective expression values irrespective of selection made

sunny_talwar — Thu, 29 Mar 2018 11:14:32 GMT

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