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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.

Labels (1)
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.