topic Re: Logic help in QlikView

Logic help

Anonymous — Tue, 04 Apr 2017 10:05:32 GMT

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

Re: Logic help

Anonymous — Tue, 04 Apr 2017 10:14:29 GMT

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

Re: Logic help

Anil_Babu_Samineni — Tue, 04 Apr 2017 11:11:26 GMT

May be this?

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