topic Re: Drill Down Question in QlikView

Drill Down Question

Mon, 24 Sep 2012 15:49:05 GMT

I have a chart to compare budget and sales by fiscal year, quarter , period , category and product id.

Drill down dimension is used for fiscal year, quarter , period , category and product id.

Sales $ expression is sum (price*qtyshipped)

Budget $ expression is sum (distinct (budgetquantity * budgetprice))

I selected the fiscal year 2013, quarter 2 and period 05 as selection. For a particular category , budget $ is shown incorrectly, but if I drill down to the product id level (i.e. by selecting category) it shows the correct values. I am unable to understand why the data is not summarized correctly at the category level.

Re: Drill Down Question

swarup_malli — Mon, 24 Sep 2012 16:10:58 GMT

Prabhat,

I have encountered similar problems in one of my projects.

One way would be try to validate it against the source data.I'm sure some of the values are missing.

Swarup

Re: Drill Down Question

Mon, 24 Sep 2012 17:50:27 GMT

Thanks Swarup

I changed the expression from sum (distinct (budgetquantity * budgetprice)) to

sum (aggr(sum(DISTINCT (BudgetQty*BudgetPrice)), ItemKey )) and it worked.