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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Logic help

Greetings ,

Can you pls help in following logic.

how to count Number of Trading Customers = Distinct count of customer if last transaction is within date prompt/filter criteria.  If no date filter is selected then criteria is YTD start date and end date.

Regards

Adarsh

2 Replies
Anonymous
Not applicable
Author

something like if getselectedcount(<your field>)>0,count(Distinct Customers),count(<Year=2017>Customers) ??

Anil_Babu_Samineni

May be this?

If(GetSelectedCount(datefieldname)>0, Count({<datefieldname = {">= $(=YearStart(datefieldname)) <= $(=Max(datefieldname ))"}>}Customers), Count(DISTINCT Customers))

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