topic Re: Problem Showing fields on a Pivot Table in QlikView

Problem Showing fields on a Pivot Table

Thu, 19 Mar 2015 18:10:06 GMT

Good day to all members of the community, I'm new to working with QlikView and hope you can help me with this problem, the matter is as follows

I'm working on a project branch, data is handled by time period, so that the data is something like

Branch Name Date Excess Amount period

East Branch East 12/01/2014 MC East 5000

East Branch East 12/01/2014 DM East 4850

East Branch East 03/12/2014 MC East 6700

The problem is that when you get data about a pivot table, add a dimension "Branch Name", "Date" and "Excess" and the field "Amount of time" as Expression (the latter with a SUM function ), so that seeing him show me well:

East Branch East 12/01/2014 MC East 5000

DM East 4850

03/12/2014 MC East 6700

Instead it shows me the result is as follows:

East Branch - - 16550

Do not show me records of fields and just makes me the sum total of the amounts, before I spend the same with the data of numerical type to be more than one not showing, so add the SUM and with that arrangement, but with this type does not eh found something about it, read it and saw that it was for the various fields and QlikView not know what approach to take to show them.

I would like to help me with this as it is not that way display that criteria apply and how to apply,

Regards

Re: Problem Showing fields on a Pivot Table

nico_ilog — Thu, 19 Mar 2015 23:14:24 GMT

Daniel,

mind adding the QV File?

Re: Problem Showing fields on a Pivot Table

Fri, 20 Mar 2015 15:30:40 GMT

I solve the problem with the text, now the pivot table shows me the text, now i realize that when I have a duplicate date it doesn't show me the two fields, It only shows once and do the SUM for the numeric value

Graphic:

Database

Sucirsal	Fecha de emisión	Propietario	Monto

Occidente	12/04/2013	MC Occidente	5700
Occidente	12/04/2013	MC Occidente	7500
Occidente	13/04/2013	MC Oriente	5000
Sur	15/05/2014	MC Occidente	3000
Sur	16/05/2014	MC Occidente	1000
Norte	18/06/2014	MC Oriente	7200
Norte	20/08/2014	MC Norte	6300

I have two times the Date: "12/04/2013", and i can only see it one

I attached the Qv file.

Thanks

Re: Problem Showing fields on a Pivot Table

nico_ilog — Thu, 23 Jul 2015 09:13:38 GMT

Hi Daniel,

So have you then resolved your own? or do you still need help?

Regards,

Nico