Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mrichman
Creator II
Creator II

How would you convert expression to set analysis?

Hi Community,

How would you convert underlying expression to set analysis?

=count(distinct if(Date2 - Today()>=7, ProductID, Null())) and ignore field name Date1=    ??

Date1 = even if this field is being filter, it will have no effect on the formula.

Thanks in advance. 

1 Solution

Accepted Solutions
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Try with:

=count(distinct {<Date1>} if(Date2 - Today()>=7, ProductID, Null()))


Saludos

View solution in original post

4 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Try with:

=count(distinct {<Date1>} if(Date2 - Today()>=7, ProductID, Null()))


Saludos

sunny_talwar

Or this

=Count(DISTINCT {<Date1, Date2 = {"$(='>=' & Date(Today() + 7))"}>} iProductID)

mrichman
Creator II
Creator II
Author

Thanks Sunny!

mrichman
Creator II
Creator II
Author

Thanks Federico