Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vkish16161
Contributor III

Can't make sense out of this! Please help

All attached is the pic for your reference. Basically

Sum(all [TRx Raw]) is returning 77 Million ( TRx Raw is in fact table)

Sum(Aggr(Sum([Trx Raw]), [Nation Flag] ))   is returning 143 Million.

How can this be possible? When there's no duplication

Nation flag is coming from Geo Dim where there are 10 other fields. Nation Flag is not the primary key in Dim_geo. 

For all the remaining fields in Dim Geo when I use a straight table and use Sum(TRx Raw) as a measure its coming out to 77 Million only.

Don't know why this is happening.

Please help.

1 Solution

Accepted Solutions

Re: Can't make sense out of this! Please help

Hi Visnhu, seems that Nation Flag relatioship with the table where TRx Raw belongs is one to more.

If you create a table with Nation Flag as dimension and Sum([Trx Raw]) as metric, how much is the sum row by row?

2 Replies
MVP
MVP

Re: Can't make sense out of this! Please help

What is the primary key in Dim_geo? How does it relate to [Nation Flag]?

Re: Can't make sense out of this! Please help

Hi Visnhu, seems that Nation Flag relatioship with the table where TRx Raw belongs is one to more.

If you create a table with Nation Flag as dimension and Sum([Trx Raw]) as metric, how much is the sum row by row?