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

[phongnnguyen]

Yes, I can do it but actually, it is not the way what i want to do. I just wanna show New status without NULL. My idea is how to make set analysis can filter within NEW status. because each ID has different status NEW or OLD.

[ChennaiahNallani]

Thanks,

Please close it

[thannila]

Please attach your sample dataset.I will try and provide a solution.

[thannila]

Try this below one:

ONLY({<STATUS={'old'}>}VALUE)