Set Analysis on different time period in the same table

[Anonymous]

Hi All,

I am facing the following problem:

I have different products in my dataset with different launch date for instance:

Product	Launch Date
Bread	03/06/2017
Pasta	14/06/2017
Biscuit	23/06/2017
Pizza	04/07/2017

Now I want to start some analysis by putting in the same table each product and comparing the performance of products in their first 7 days. I am able to perform a set analysis just on fixed interval of time (i.e. with a set analysis on YearWeek field) but not in this case where I just want to compare the performance of products in their first 7 days. I have tried with loading the above table and by making a P() set analysis in the field "Date", but seems not working.

Attached are some test-Data.

the following table (based on the attached test Data) is my target to reproduce in Qlik:

	Launch Date	Revenue
Bread	03/06/2017	280.5
Pasta	14/06/2017	201
Biscuit	23/06/2017	114
Pizza	04/07/2017	816.5

Any help would be really appreciated,

thanks in advance.

Giulio

[beck_bakytbek]

Hi Giulio,

look at this: Set Analysis for certain Point in Time

i hope that helps

Beck

[Anonymous]

Hi beck,

thanks for your reply, unfortunately, this URL doesn't fit my requirement! I am perfectly able to make any set analysis with fixed period of time in the same table. Here I am asking another question, I want to compare in the same table the first week after the Launch date so it is not a fixed range of time.

Thanks,

Giulio

[beck_bakytbek]

ok, i see your point, i try to create an example and will post it to you

Beck

[Anonymous]

Hi Team,

I am also facing same kind of challenge.

Re: Promotion event wise Data - last 'n' Days

Please help us.

[antoniotiman]

Hi Giulio,

like this

Regards,

Antonio

[Anonymous]

It's not for set analysis - sets are evaluated over the whole data set,not per table row.  You can implement it using if() function without any problems.

[Anonymous]

Hi Antonio,

thanks for your reply,

Apologize I was no clear.. I need the performance during the first 7 days since the product was launched.

I have updated the post. BTW follows the tables that I want to reproduce in Qlik.

Thanks again.

[Anonymous]

Hi Michael,

Thanks for your reply.

This is was what I was thinking, I was believing that with some tricks by using the P() function in the set analysis could be possible.

BTW I really want to avoid if statement when possible for performance reason, do you think that one IF like this could not generate problems?

[Anonymous · Accepted solution]

Well, you don't have a choice.  It is not a place where you can use set.  Speaking of performance - your if() expressions will be simple, they are not doing to make any noticeable impact.