Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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