Greater <= & >=

[dhanavindhan]

Hi Experts,

I have a table with negative and positive values. My filter was this (Freedays>=14 & Freedays<=14).

Like this,

If I click on any one it should filter the record in the table for the corresponding condition. I don't know how to do this. Pls help me.

Thanks in advance

Regards,

Dhana R

[olivierrobin]

hello

you have to associate each row of your input table to one of the values of your filter, say

let filter=(if value<14,'less than 14','gt than 14')

create a list box showing filter

[dhanavindhan]

Thanx for the reply.

Could you pls eloborate this? I am not getting what you are coming to say.

[dhanavindhan]

Click on the image it will show you all the columns.

[olivierrobin]

you say you have positive and negative values.

I understand this is stored in a field which i called "Value"

is this correct ?

if not, you have to find a way to determine that value (diffrence between 2 fields of someting else)

[dhanavindhan]

ok

[Peter_Cammaert]

You can use Set analysis with an expression search. The actual expression will be chosen by selecting one from a listbox and patching it into the set analysis expression using $-sign substitution.

For example (by lack of further details from your side, I'm inventing my own situation here):

• In your script, either create a date island containing your two expressions as text Call the field "Filter"
• Put a listbox on your sheet that displays Filter values. Select one and in properties->General, enable "Always one selected value".
• Now create a Straight table, and in all expressions add the following set analysis expression. Use a field that has a unique value for every row in your facts table (an ID or a Transaction number):
  ... {<[SRR No] = {"=$(=Filter)"}>} ...
  Test

You can also get this effect using a variable and an Input Box object instead of a date island.

Are you sure that you want an overlap between the two filters? Or do you prefer something like Freedays <= 14 and Freedays > 14?