Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.