Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sai_Mohan
Contributor III
Contributor III

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

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!

 

Labels (1)
2 Solutions

Accepted Solutions
hector
Specialist
Specialist

Hi

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

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

regards

View solution in original post

Kushal_Chawda

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) 

View solution in original post

5 Replies
hector
Specialist
Specialist

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

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
Contributor III
Contributor III
Author

Hi @Kushal_Chawda 

Thanks for the help!

It works fine 

Sai_Mohan
Contributor III
Contributor III
Author

Hi @hector 

Thanks for the help!

It works fine 

PDurnall
Contributor II
Contributor II

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)