topic Re: Data Model issue!!! in QlikView

Data Model issue!!!

ganeshreddy — Thu, 27 Aug 2015 13:14:38 GMT

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.

Re: Data Model issue!!!

ganeshreddy — Thu, 27 Aug 2015 13:37:27 GMT

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.

Re: Data Model issue!!!

ganeshreddy — Fri, 28 Aug 2015 11:28:26 GMT

Can any one help me on this!!!!

Re: Data Model issue!!!

PrashantSangle — Fri, 28 Aug 2015 11:35:55 GMT

Hi,

Try AGRR() in your expression

modify your expression like

sum(aggr(YourExpression,Dimension))

Regards

Re: Data Model issue!!!

kavita25 — Fri, 28 Aug 2015 11:41:00 GMT

what is the expected Output...

For East & West Region??

Re: Data Model issue!!!

ganeshreddy — Fri, 28 Aug 2015 11:51:42 GMT

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

Re: Data Model issue!!!

ganeshreddy — Fri, 28 Aug 2015 11:53:25 GMT

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.

Re: Data Model issue!!!

ganeshreddy — Fri, 28 Aug 2015 11:55:14 GMT

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

Re: Data Model issue!!!

kavita25 — Fri, 28 Aug 2015 11:57:23 GMT

Yess...

check the qvw..

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

Re: Data Model issue!!!

ganeshreddy — Fri, 28 Aug 2015 12:19:27 GMT

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.

Re: Data Model issue!!!

kavita25 — Fri, 28 Aug 2015 12:22:00 GMT

Yeah...Even in the modified qvw I have used the same field...

Previously i had Used Group Name...

Its good you got ur solution

Re: Data Model issue!!!

ganeshreddy — Fri, 28 Aug 2015 13:42:44 GMT

Hi,

I found one more issue here Kavita, drill down in first table is not working for Total Equipment metric, can you suggest me form which fields i should aggregate again.

Thanks,

Ganesh.