topic Re: Can't get right value in QlikView

Can't get right value

Sun, 15 Mar 2015 13:17:52 GMT

I have a problem for this relations

I have a table for conversion as this

ItemId Factor FromUnit ToUnit

and I have a table for transactions as

ItemId Qty GroupId UnitId

my question, when I set an expression in the chart as (Sum(Qty) for ItemId / Sum(Qty) for GroupId related with ItemId)

When I do it that I cant right value for conversion equation.

Re: Can't get right value

fred_s — Sun, 15 Mar 2015 14:04:01 GMT

Can you share your file, with some (sample) data?

Grtz Fred

Re: Can't get right value

Mon, 16 Mar 2015 10:16:24 GMT

Hi fadibarri

Can you Share your File

Re: Can't get right value

morganaaron — Mon, 16 Mar 2015 10:21:40 GMT

How are you writing the expression?

If you want the % breakdown for each group of the items within it, try creating a table with GroupID and ItemID as your dimensions, then use Sum(Qty) / Sum(Total <GroupID> Qty) as your expression.

Otherwise, what is it you want from your conversion table?