topic Re: registration analysis in QlikView

registration analysis

Tue, 26 Aug 2014 08:44:24 GMT

Hi guys,

Hoping you can help me I have 3 excel files each with a registration e-mail , and sets of parameters for being active for that particular wave.

So i wanted to end up with stats for the following I tried using count of email address for each wave but wasn't working

Active participants this wave

Participants which are active for this wave but not for the last

Participlants which where active for the last wave but not this one.

Thanks !

Sarah

Re: registration analysis

sujeetsingh — Tue, 26 Aug 2014 08:50:04 GMT

Sarah,

You need to come in details with all fields and then explain .

Seems your script require a conditional statement to derive these things.

Re: registration analysis

Tue, 26 Aug 2014 08:56:22 GMT

Hi Sujeet

Thanks for your help im using the fields

Email, leasing company (for leasing companies =vLeaseCo), and activity. Have a separate spreadsheet for each wave so Im loading the same data from each with outer joins

Thanks

Sarah