topic Email instances count in QlikView

Email instances count

saradhi_it — Fri, 04 Aug 2017 06:36:30 GMT

Hi Guys

i have some requirement its about calculate email instances based on products there are two scenarios

scenario1: in store i have 5 products i want know which user was buying his first purchase in which product i need to calculate based on the email id and parallelly what is second purchase like this

Products	1	2	3	4	5
Product1	8	1	1	1	1
Product2	12	2	-	-	-
Product3	17	4	3	3	2
Product4	8	2	-	-	-
Product5	8	2	-	-	-

the required user want to know how many purchased product1 for the first ,second,third,....etc i achieved partially the above issue by using autonumber but still missing for s,iome instances

Another sccerio2 is very tricky , the user want to know the customers who bought product 1 want to know remaining transactions whether they bought same product again or something else or didn't buy remaining products followed by remaining products

i can't provide samll output for the second scenario 2 it was very difficult for me to create still any doubts can ping me

Regards

Saradhi

Re: Email instances count

Anil_Babu_Samineni — Fri, 04 Aug 2017 08:35:11 GMT

How you are getting 50 ??

Re: Email instances count

saradhi_it — Fri, 04 Aug 2017 08:48:03 GMT

anil

as i mentioned in the post don't compare the your output with my output file i just added some random numbers its very difficult to calculate these requirement in the excel just see the output format only not numbers

Re: Email instances count

Anil_Babu_Samineni — Fri, 04 Aug 2017 08:50:39 GMT

At least, We need to know the logic behind. Let me explain here if you want to show who purchase first then expression should be this

Only({<Date = {'$(=Min(Date))'}>}Email)

But, When we talk about number at least some logic need to work on it?

Re: Email instances count

Anil_Babu_Samineni — Fri, 04 Aug 2017 08:52:29 GMT

I know, This is not make sense because i simply run up with Random values

Re: Email instances count

saradhi_it — Fri, 04 Aug 2017 14:45:01 GMT

HI anil

i attached sample output