Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Count visit with Asynchronous Date in same table

Hi,

I've a fact table with this information :

DateVisit     IDClient     DateTransformCustomer

2014/03/01     1               2014/04/01

2014/05/01     1               2014/04/01

2014/02/01     2               2014/02/18

2014/05/01     2               2014/02/18

The date transform is the date when a potential customer become a real customer

I want to see the number of visit by month and the number of customer transformed

MonthVisite          countVisit          CountTransformedCustomer

01 - Jan               0                         0

02 - Feb               1                        1

03 - March            1                        0

04 - April               0                       1                

05 - May               2                       0

Thank you in advance

1 Reply
mov
Not applicable

Re: Count visit with Asynchronous Date in same table

See  attached example