Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
i want to show you an strange issue.
I have the table 1.
I don't know why but when i use the sum expression the values are wrong (see table 2))...
The real value of sum is 51.
Can someone help me?
Thanks!
hay que ver qué hay en los QVD...Intuyo q están en SUBSCRIPTIONS. Qué hay acá? Lo más probable es que tengas varios registros por cada user_id.
Le estás diciendo a Qlikview:
1- Leé las claves de SUBSCRIPTIONS.QVD y creá dos campos con nombres diferentes por cada una (acá es muy probable que estén repetidos)
2- Leé de DEAL_EXTERNALS.QVD tales datos, y emparentalos con cada clave leída.
Si tenés por ejemplo user_id A, A, A, B, B, C, C, C, C,... te va a poner los datos de quantity que se corresponden en la segunda tabla con A, 3 veces, con B, 2, y así....
Tenés que tener un buen conocimiento de qué hay en cada qvd antes de leerlo.
hello
why not rename the field with no points from the script
DEAL_EXTERNAL.quantity_A as Quantity
regards
sorry, there was an error loading the pictures....now are ok.
could you post an image of your table view?
Hi Juan,
I attached two images in the main question.
Thanks
gerardo
Enviado el: jueves, 19 de abril de 2012 04:36 p.m.
Para: Pauza, Gerardo
Asunto: - Re: sum expression error
QlikCommunity <http://community.qlik.com/index.jspa>
Re: sum expression error
created by Juan Fibonacci <http://community.qlik.com/people/dragonauta> in New to QlikView - View the full discussion <http://community.qlik.com/message/212103#212103
i meant an image of your internal table view (CTRL + T)
Juan, here is the table internal view
SUBSCRIPTIONS_A:
LOAD
user_id as %Key_USER_ID_A,
user_id as user_id_A
INNER Join
load
Year(created) & Num(Month(created),'00') & Num(Day(created),'00') as %Key_CREATED_DEAL_EXTERNALS,
user_id as %Key_USER_ID_A,
user_id as user_id_A,
quantity as quantity_A,
id as deal_externals_id_A
where `external_status` = 'A';
Enviado el: jueves, 19 de abril de 2012 05:44 p.m.
Para: Pauza, Gerardo
Asunto: - Re: sum expression error
QlikCommunity <http://community.qlik.com/index.jspa>
Re: sum expression error
created by Juan Fibonacci <http://community.qlik.com/people/dragonauta> in New to QlikView - View the full discussion <http://community.qlik.com/message/212127#212127
Hi,
If it is possible, please attach the actual qvw file.
Regards
Andrew Hudson
Hi Andrew,
I send you the qvw.
Sorry but i had to reduce the data.
Thanks for any advice
Gerardo
Enviado el: jueves, 19 de abril de 2012 09:32 p.m.
Para: Pauza, Gerardo
Asunto: - Re: sum expression error
QlikCommunity <http://community.qlik.com/index.jspa>
Re: sum expression error
created by Andrew Hudson <http://community.qlik.com/people/adhudson> in New to QlikView - View the full discussion <http://community.qlik.com/message/212163#212163
Hi,
I found that your data has duplicate values. Also Your Table has no Unique key that is why you are getting different values when displaying in table and when you are summing up. I attached your modified file with RowNo() added to a table. Hope it helps you.
Regards,
Jagan.