challenging Request

[alec1982]

hi all,

I have a challenging request to create a pivot table as show in my attached excel file

the source is the upper table which looks like

5/18/2016	test	$ 254.00
6/15/2016	test	$        200.00
7/20/2016	test	$        500.00
8/17/2016	test	$        300.00

and the result table is as follow

Date	5/18/2016	6/15/2016	7/20/2016
5/18/2016	$      (54.00)	$        246.00	$     46.00
6/15/2016		$        300.00	$   100.00
7/20/2016			$ (200.00)

I have attached the excel file to show how i calculate the numbers..

I couldn't figure out a way to do it in QlikView so any help is appreciated

[sunny_talwar]

Yes, I did not go into the the nitty-gritty hoping that Alec will be able to get that resolved. I focused on getting the numbers right. But you are right, Alec might need to make changes based on his final requirement.

[alec1982]

while this works well in QlikView and is greatly appreciated. I have to do it in parallel in QlikSense but it doesn't work.

Any one has experience in Sense?

[alec1982]

I will go ahead and post it on Sense community as well.

[sunny_talwar]

Sure thing, in the meantime I would suggest to close this thread by marking any correct and helpful answers since you have moved the discussion to a new thread now.

Best,

Sunny

[alec1982]

Will do. give me few hours to find a solution and I will close this one as solved by you. Thanks for all the help.

[Anonymous]

take the pivot table and select the pivot table and taken date and expression is sum (field name) and after

that right on that on the table select than change into horziontally

[alec1982]

thank you.