Set Analysis is Not working

[Lena4]

I'm building a chart and have used the following code to isolate values for a particular timeframe. The problem is that the 'VALUE={">100"}' part of the set expression is not being recognized.  It only happens when I use the Timestamp syntax. Does anyone know of a workaround? 

[Lech_Miszkiewicz]

There are 2 potential issues here:

1. you are using Value >100 and in other place you have Value = 'Open'. That indicates to me tha field has mixed datatypes which I assume can cause issues when trying to do numerical comparisons. In my preactice I never allow for such scenario as it creates confusion and mess. Id rather load 2 separate fields (one for numbers and one for text), or create flags for thos conditions.

2. your syntax is wrong here:

you have [Value= ........so you are missing closing bracket for field Value. You can do either: [Value]=, or just Value= as that field does not require brackets as it has no special characters or space in its name.

cheers

[Bhushan_Mahajan]

@Lena4 Please provide expression, since the screenshot expression is not visible properly.

@Lech_Miszkiewicz I think second issue is there in the expression due to which it is not working 

[Lena4]

Hi @Bhushan_Mahajan & @Lech_Miszkiewicz 

Here's the corrected expression. The field does have mixed data types, but I'm able to distinguish between the different types by using the location field.  

(Count(distinct{< Location={'A'},VALUE={">100"},TIMESTAMP={"=concat(DISTINCT IF(VALUE='Open' AND Location='P.1' , TIMESTAMP),',')"}> *<TIMESTAMP=                                                       {"=concat(distinct IF(VALUE='Open' AND Location='P.11. ', TIMESTAMP), ',') "}>
             +<TIMESTAMP={"=concat(DISTINCT IF(VALUE='Open' AND Location='P.2 ' , TIMESTAMP),',')"}> *<TIMESTAMP=                                                                                                                        {"=concat(distinct IF(VALUE='Open' AND Location ='P.12 ', TIMESTAMP), ',') "}>
              +<TIMESTAMP={"=concat(DISTINCT IF(VALUE='Open' AND Location='P.3', TIMESTAMP),',')"}> *<TIMESTAMP=                                                                                                                          {"=concat(distinct IF(VALUE='Open' AND Location='P.13 ', TIMESTAMP), ',') "}>}TIMESTAMP))

[Lech_Miszkiewicz]

Well. You do you. That field is a single field so you cant expect it to work differently on different rows. 
For testing you can just put Value field in filter pane in UI and search >100

see if you get correct results!

I say numerical searches based on operators may not work properly in this case.