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: 
karolina_
Creator II
Creator II

set analysis with dates

Hi All

I cannot make set analysis work with fields - StartMonth and EndMonth as in attachement.

I tried it with as StartMonth, date( StartMonth,'YYYY-MM-DD'), $(=date( StartMonth,'YYYY-MM-DD')) nothing works

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Karolina,

You can't use Set Analysis.

Set Analysis is evaluated per Chart, not per Rows.

So, use like this

Count(DISTINCT If([Hire date] >= StartMotnh and [Hire date] <= EndMonth, ID))

Regards,

Antonio

View solution in original post

4 Replies
srishsum2017
Creator
Creator

Hi, Please use single quotes at the place of double quotes

Sumit Kumar Srivastava
vardhancse
Specialist III
Specialist III

Hi Change the expression to

=count({<[Hire date]={"$(='>=' & StartMotnh & '<=' & EndMonth)"}>}DISTINCT ID)

tresesco
MVP
MVP

Try like:

Count(DISTINCT if([Hire date]>=StartMotnh and [Hire date]<=EndMonth, ID))

Capture.PNG

antoniotiman
Master III
Master III

Hi Karolina,

You can't use Set Analysis.

Set Analysis is evaluated per Chart, not per Rows.

So, use like this

Count(DISTINCT If([Hire date] >= StartMotnh and [Hire date] <= EndMonth, ID))

Regards,

Antonio