Pivot Table

[soha1902]

Hi All,

I have following Data:

ProdID	Product	Activated	Deactivated
1	Prod A	02/15/13
2	Prod B	08/05/13
3	Prod C	01/07/14
1	Prod A		02/10/14
2	Prod B		02/26/14
1	Prod A	11/15/14

Now my requirement is, if any Product is active then its price will be display as 10 and if it is deactive then its price will be 0.

For example Prod A is activated on 15 feb 2013 and deactivated on 10 Feb 2014 so from 15th Feb 2013 till 10Feb 2014 its price will be 10. On 10th Feb 2014 Prod A was deactivated and on 15 Nov2014 again got activated so from 10th Feb 2014 to 15 Nov 2014 its price will be 0.

I need to add Price column as a expression and Week column should be pivoted.

Can any one suggest me, how to implement this.

The resultant table shold look like this for Product A

ProdID

Product

Activated

Deactivated

2/18/2014

2/25/2014

-------------'

2/7/2014

2/14/2014

2/21/2014

-------------'

11/14/2014

11/21/2014

till cureent date

1

Prod A

02/15/13

10

10

10

0

0

0

10

10

2

Prod B

08/05/13

3

Prod C

01/07/14

1

Prod A

02/10/14

2

Prod B

02/26/14

1

Prod A

11/15/14

Thanks in advance.

[soha1902]

Thanks a lot liron....

[soha1902]

Hi Liron,

I have one requirement....if you have some time can you please suggest me abt following:

http://community.qlik.com/thread/151216

Thanks.