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: 
alex-wb
Contributor III
Contributor III

Set analysis

Hi All, does anyone know why I get two different results when I use the following codes:

Count({$<
Fault_Closed_Day={">=$(=DATE(Today()-366))"},
Fault_Closed_Day =-{" "},
SLA_Flag= {'N'},
SA_Flag = {'Y'}
>}Fault_Ref)

or

Count({$<
Fault_Closed_Day={">=$(=DATE(Today()-366))"},
SLA_Flag= {'N'},
SA_Flag = {'Y'}
>}Fault_Ref)

 

I though the code would give the same results since the first one is saying the fault closed date must be greater than or equal to 366 days ago and not blank, the second one says that but without the not blank part. 

Labels (1)
1 Reply
anvalo00
Contributor II
Contributor II

Hola,

Cuentan cosas distintas (Ref_fallo o Fault_Ref)

Saludos,