new to qlikview

[srujanaponnuru]

Hi, the data is shown below  

Products	Cost	Start date	End date
Desktop	$300	14-Jan-15	14-Feb-15
Voip	$50	15-Jan-15	15-Feb-15
Mouse	$20	16-Jan-15	16-Feb-15
Desktop	$200	17-Jan-15	17-Feb-15
Desktop	$200	18-Jan-15	18-Feb-15
Desktop	$200	19-Jan-15	19-Feb-15
Voip	$50	20-Jan-15	20-Feb-15
Voip	$50	21-Jan-15	21-Feb-15

I need help on this.

I want to create  start date and end date as calendar.

and according to that my pivot table needs to fetch the above data and at the same time i want to calculate the sum of cost of similar product.

for example :L the desktop between those dates , it has to sum up and give me the result in pivot table.

please help me out.

Srujana

[lironbaram]

hi

have a look at the attach example

[jagan]

Hi Srujana,

Are you looking similar to the attached one?  PFA file hope it helps you.

Regards,

Jagan.