How can I use greater than(>=) in Set analysis

[Sai_Mohan]

Hi All,

I need to get distinct count of user_id by giving two condition .

1st Cond = 'Completed = 'yes' (Completed is column name)

2nd cond = 'Date >= '07/01/2020' (date s column name)

I have used:

count(Distinct{<Completed = {'Yes'}, Date = {">=$ ('07/01/2020')"}>} UserID) - Not getting any error but getting value as zero.

Note : I am unable to give greater than symbol.

Thanks in Advance!

[hector · Accepted solution]

Hi

if "date" is a valid date field (interpreted by Qlik), you can use

count(Distinct{<Completed = {Yes}, Date = {">=07/01/2020"}>} UserID)

regards

[Kushal_Chawda · Accepted solution]

You don't need $ for hard-coded values. Just encapsulate value in in double quotes. Make sure that the value format should match with Date field format.

count(Distinct{<Completed = {'Yes'}, Date = {">=07/01/2020"}>} UserID) 

[Sai_Mohan]

Hi @Kushal_Chawda 

Thanks for the help!

It works fine 

[Sai_Mohan]

Hi @hector 

Thanks for the help!

It works fine 

[PDurnall]

Also to note that

count(Distinct{<Completed = {Yes}, Date = {">=07/01/2020"}>} UserID) Works 

but if you put a space here between the >= and the Date like below it doesn't work 

count(Distinct{<Completed = {Yes}, Date = {">= 07/01/2020"}>} UserID)