how to show number of repeated customers in each period using set analysis

[Naren123]

I need to find number of repeated customers who made transaction more than once in a given period.

scenario 1:

if i select the month it should show the number of customers who made transaction more than once in the selected month.(which should not consider the customer entry as 2 if he had  made transaction in the previous month, it should count the entry as 1 if particular customer repeats from previous month to selected month)

scenario 2:

if i select the quarter it should show the number of customers who made transaction more than once in the selected quarter.

scenario 3:

if i select the year it should show the number of customers who made transaction more than once in the selected year.

Note: i have period filter which will pass the date range accordingly based on the selection(month,quarter,year)

i am using fields: Customer code, Doc_date

Please help in this regard, 

[Naren123]

I need to find number of repeated customers who made transaction more than once in a given period.

scenario 1:

if i select the month it should show the number of customers who made transaction more than once in the selected month.(which should not consider the customer entry as 2 if he had  made transaction in the previous month, it should count the entry as 1 if particular customer repeats from previous month to selected month)

scenario 2:

if i select the quarter it should show the number of customers who made transaction more than once in the selected quarter.

scenario 3:

if i select the year it should show the number of customers who made transaction more than once in the selected year.

Note: i have period filter which will pass the date range accordingly based on the selection(month,quarter,year)

i am using fields: Customer code, Doc_date

Please help in this regard, 

[Channa]

IF (count(Transation)>1 , customerID)

or

=If(Aggr(count(Transactions),Customer)<1,Customer) use as ur customer Dimension

[Naren123]

Thanks for the reply channa, but  i am supposed to calculate the count in front end using set expression, in a KPI object.

i am using fields doc_date as transaction date and customer code as customer.

Thanks

[Channa]

Count(Distinct {<Customer={"=Count(Transaction)>1"}>} Customer)

it have distinct customers who has more than one transactions

[Naren123]

Hi channa,

Please find the sample application for your reference.

i am not getting the output as expected, here i need to omit the flag=x

thanks in advance

[Channa]

put this

= Count(Distinct {<customer_id={"=IF(return_flag<>'X',Count( distinct Date)) >1"}>} customer_id)

[Naren123]

thanks, but still not omitting the flag , however it shows the desired output on making any month selections. please refer the attached screenshot.

required output: took from data

current output: took from qlik application

after selection: took after selecting month in qlik application which shows required output on selection 

[Channa]

find attach result

[Channa]

please take QVF

[Naren123]

thanks it is showing 4 on the whole omitting the flag which is correct, but my requirement is to show the repeated count on month wise, which i posted earlier, in our case it shows null,

the actual output should be jan 3 and feb 2,  since customer 4 holds repeated date in jan and feb