Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ganeshreddy
Creator III
Creator 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
kavita25
Partner
Partner

Yess...

check the qvw..

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

View solution in original post

11 Replies
ganeshreddy
Creator III
Creator III
Author

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
Creator III
Creator III
Author

Can any one help me on this!!!!

PrashantSangle

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.
kavita25
Partner
Partner

what is the expected Output...

For East & West Region??

ganeshreddy
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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

kavita25
Partner
Partner

Yess...

check the qvw..

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

ganeshreddy
Creator III
Creator III
Author

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.