Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
asalamun
Contributor
Contributor

Get the count of a value using the weekYear

I'm using WeekYear as a dimension, but I am trying to calculate the count of records that have a DateInitiated prior to WeekYear dimension value. So for weekYear being 1-2017 I need the count of everything initiated prior to that date

here is what I am trying now, but nothing is coming up.

=count(distinct {<DateInitiated={'<WeekYear'}>} RecordID)

Thank you

3 Replies
Anil_Babu_Samineni

Perhaps this?

=count(distinct {<DateInitiated={$('<' & =Max(WeekYear)-1)}>} RecordID)

OR

=count(distinct {<DateInitiated={"<$(=Max(WeekYear)-1)}>} RecordID)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
asalamun
Contributor
Contributor
Author

The first gave me a zero value, and the second one just gave an error

Anil_Babu_Samineni

Will you able to provide sample?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful