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,
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
