Filter with conditional in set analysis

[phongnnguyen]

Hi there,

I have a problem with my set. I want to just filter all row which have status "Old" . Like below example:

My original straight table is:

ID	value	status
a11	123	Old
b11	456	Old
c11	789	New

with status is a Variable $(v_status): if(createdate>'01/01/2018','new','old')

and this is what I want to show

Header 1	Header 2	Header 3
a11	123	Old
b11	456	Old

Thanks for your help

[yenumulagopi]

Hi Phong,

Please find the attachment. May be it will help you

Thank You,

Gopi

[nishanthi_8]

=only({<status={'$(v_status)'}>}status) , provided in v_status variable the value is 'old'

[ChennaiahNallani]

try like below

Load

ID,

value,

if(createdate>'01/01/2018','new','old') as Status

from table....

variable

Table Fileds,

ID

value

=$(vStatus)

and in Properties Uncheck Include null values in all fields.

[Anil_Babu_Samineni]

What is the variable storing? Can you share that value with me.

[phongnnguyen]

thanks your help, but My variable v_status is: if(createdate>'01/01/2018','new','old')

[phongnnguyen]

my variable v_status is if(createdate>'01/01/2018','new','old'). thanks for your consider

[ChennaiahNallani]

try like below

Load

ID,

value,

if(createdate>'01/01/2018','new','old') as Status

from table....

variable

Table Fileds,

ID

value

=$(vStatus)

and in Properties Uncheck Include null values in all fields.

[nishanthi_8]

So createdate contains many dates right ? Which one it is comaparing against '01/01/2018' if you use it in the textbox? So better add date dimension to the table so that you will get clear view.So try with the simple expression like this :

     if(createdate<01/01/2018','old')

[phongnnguyen]

thanks for your reply but I dont know why uncheck include null value of ID column . I think your way will be working if can uncheck in v_status column