- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yess...
check the qvw..
I am not sure about the values whether it'showing correct or not..but the values are matching now....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can any one help me on this!!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try AGRR() in your expression
modify your expression like
sum(aggr(YourExpression,Dimension))
Regards
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what is the expected Output...
For East & West Region??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
FYI...East and west field sum is not matching with Total in first table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yess...
check the qvw..
I am not sure about the values whether it'showing correct or not..but the values are matching now....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- « Previous Replies
-
- 1
- 2
- Next Replies »