Discussion Board for collaboration on QlikView Scripting.
i have 2 excels sheet
2) product quantity
how to make sum of qty like ( after distinct, sum should come.. i guess ....)
product 101 sum should be 178
product 102 sum should be 154
product 106 sum should be 199 and so
i need to show it on chart
kindly help me
= Aggr(Sum (qty),productcode)
Load them into qv as-it-is(two seperate tables) with proper table names. The two tables would be linked with productcode field. Now in the front-end chart:
see the attached example:
its not making sum
Is this what you wanted to achieve?
I have attached a qvw in which I have created a chart of the products' "name" as a Dimension (you can put the "productcode" instead) and "Sum( DISTINCT (qty))" as an Expression.
Hope you find it useful
(ooxml, embedded labels, table is Product);
(ooxml, embedded labels, table is [product quantity]);