Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New Clients

I need to display only new clients for a certain period, for example for 2014, or for 1 month only. Please help me.

4 Replies
MK_QSL
MVP
MVP

Create a Year in your script...

Year([Start Date]) as Year

Now use below in your table

COUNT{<Year = {'$(=Year(Today()))'}>}Distinct UserNS)

PradeepReddy
Specialist II
Specialist II

Create one Master Calender  table using the min/max start dates and join that to main table.

Count(Distinct{<CLNDR_YR={'$(=Year([Start Date]))'}>}UserNS)

Regards

Pradeep

Not applicable
Author

If i try min[Start Date] as [min date] it say to me that it is invalid expression

Not applicable
Author

And how i do it for a period? I work only for present year.