topic Filter with conditional in set analysis in QlikView

Filter with conditional in set analysis

phongnnguyen — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Filter with conditional in set analysis

yenumulagopi — Thu, 26 Jul 2018 04:15:56 GMT

Hi Phong,

Please find the attachment. May be it will help you

Thank You,

Gopi

Re: Filter with conditional in set analysis

nishanthi_8 — Thu, 26 Jul 2018 04:40:28 GMT

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

Re: Filter with conditional in set analysis

ChennaiahNallani — Thu, 26 Jul 2018 05:17:34 GMT

try like below

Load

ID,

value,

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

from table....

variable

Table Fileds,

value

=$(vStatus)

and in Properties Uncheck Include null values in all fields.

Re: Filter with conditional in set analysis

Anil_Babu_Samineni — Thu, 26 Jul 2018 05:29:47 GMT

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

Re: Filter with conditional in set analysis

phongnnguyen — Thu, 26 Jul 2018 05:33:31 GMT

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

Re: Filter with conditional in set analysis

phongnnguyen — Thu, 26 Jul 2018 05:35:01 GMT

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

Re: Filter with conditional in set analysis

ChennaiahNallani — Thu, 26 Jul 2018 05:42:51 GMT

try like below

Load

ID,

value,

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

from table....

variable

Table Fileds,

value

=$(vStatus)

and in Properties Uncheck Include null values in all fields.

Re: Filter with conditional in set analysis

nishanthi_8 — Thu, 26 Jul 2018 05:49:03 GMT

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')

Re: Filter with conditional in set analysis

phongnnguyen — Mon, 30 Jul 2018 03:10:42 GMT

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

Re: Filter with conditional in set analysis

phongnnguyen — Mon, 30 Jul 2018 03:15:44 GMT

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.

Re: Filter with conditional in set analysis

ChennaiahNallani — Mon, 30 Jul 2018 04:58:16 GMT

Thanks,

Please close it

Re: Filter with conditional in set analysis

thannila — Mon, 30 Jul 2018 05:25:14 GMT

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

Re: Filter with conditional in set analysis

thannila — Mon, 30 Jul 2018 05:44:17 GMT

Try this below one:

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