Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
ganeshreddy
Contributor III

Data Model issue!!!

Hi All,

Here we got two pivot tables with different drill down groups, first table drill down is from profit center table and second one is from equipment table. The issue i am facing here is, the last metric(Total equipment) is showing wrong values for the field values but total value is correct. I tried to move profit center table, and connected to equipment table, in this case i am only getting last metric values right not the reaming metrics. I am suspecting that some ware in the fact table(WOsummary) i am doing my calculations wrong , means not aggregating values with profit center drill down group. Can anyone provide me solution for my problem. Please find the attached QVW.

Best Regards,

Ganesh.

1 Solution

Accepted Solutions
Partner
Partner

Re: Data Model issue!!!

Yess...

check the qvw..

I am not sure about the values whether it'showing correct or not..but the values are matching now....

11 Replies
ganeshreddy
Contributor III

Re: Data Model issue!!!

FYI, the last metric in first pivot table is showing total correct but not east and west values. This is what my actual problem. sunindia please spend some time in this.

Thanks,

Ganesh.

ganeshreddy
Contributor III

Re: Data Model issue!!!

Can any one help me on this!!!!

Re: Data Model issue!!!

Hi,

Try AGRR() in your expression

modify your expression like

sum(aggr(YourExpression,Dimension))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Partner
Partner

Re: Data Model issue!!!

what is the expected Output...

For East & West Region??

ganeshreddy
Contributor III

Re: Data Model issue!!!

Hi kavita,

Expected output(total) is 206 only it is matching with below table, but values for east and west are wrong i am not sure about the values because it is a limited load.

Regards,

Ganesh

ganeshreddy
Contributor III

Re: Data Model issue!!!

Hi Max dreamer,

i tried this but here it is count and i am not sure about dimention because it is with drill down dimention.

Regards,

Ganesh.

ganeshreddy
Contributor III

Re: Data Model issue!!!

FYI...East and west field sum is not matching with Total in first table.

Partner
Partner

Re: Data Model issue!!!

Yess...

check the qvw..

I am not sure about the values whether it'showing correct or not..but the values are matching now....

ganeshreddy
Contributor III

Re: Data Model issue!!!

Thanks a lot Kavita, a slight change i took following exp

sum(aggr(Count({<EquipmentGroupName=,EquipmentClassName=,EquipmentCategoryName=,EquipmentModelName=>}distinct EquipmentId),EquipmentModelName))    

i have changed dimension for aggregation.

Best Regards,

Ganesh.