This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
The following expression doesn't work for me:
sum( Qty*Carts_Per_Item) /
sum(TOTAL <Style> Qty*Carts_Per_Item)
Any idea why?
SUM(TOTAL <A> SUM)/
View solution in original post
Would you be able to post a sample?
What do you mean by "it does not work"? Syntax seems to be OK, if it does not return the results you expect then as Sunny suggests post some sample data and expected results.
Are Qty and Carts_Per_Item fields in the same table?
My issue is somewhere else:
I would like to have the relative quantity by dim A,
or share of A
SUM(SUM)/ SUM(TOTAL <A> SUM)
What am i doing wrong??
May be you need this
Yes, in my original model the 2 fields are in different table.
Could that cause an issue?
I simplified it just to check in the above data (sum by dim A), but it doesn't work either,,
No, it gives the same result as the % column..
Just Attached the data..
This is what you want to get, right?
I guess create a chart with
This doesn't give you what you want, really?