Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.


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.



2 Replies
Valued Contributor

Re: Logic help

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

Re: Logic help

May be this?

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

Life is so rich, and we need to respect to the life !!!
Community Browser