topic Displaying correct Total at the bottom in QlikView

Displaying correct Total at the bottom

Thu, 08 Jul 2010 06:24:58 GMT

Hi,

I am having three expression, where the third expression is (2nd Expression / 1st Expression). I am able to get the correct result for all the rows, except for the total (displayed at the bottom). I have attched the file. Is there any work around for that.

Thanks

Displaying correct Total at the bottom

Thu, 08 Jul 2010 10:36:35 GMT

Hi Santhosh,

I have few doubts in you qvw.

Why the Product B has all catogories and Not for A and C. I have just tried ?

Don't this Expression product your desired output

Sum(AGGR(sum( {<Range= {'0 - 10', '11 - 20', '21 - 30', '31 - 40', '41 - 50'}>} Sales1 ),Product,Category))

Displaying correct Total at the bottom

Thu, 08 Jul 2010 15:20:05 GMT

Hi Srini,

The QVW shows the top 10 categories and that is why it shows the desired result.

Your expression doesn't check for top 10 and hence it is error in the result. My problem is only in the 'Sales' expression. It doesn't give me the correct total.

Thanks