topic Re: Need help with straight table in QlikView

Need help with straight table

venkatg6759 — Thu, 26 Sep 2013 13:45:49 GMT

Hello ,

I have a table like this

NO Name Field bad

11 tradelink dollar 10%

12 capital security 20%

11 tradelink dollar 20%

If i am doing the sum of rows i am getting

30%

11 tradelink dollar 10%

11 tradelink dollar 20%

How can i aggregate and show them only one time like this

11 tradelink dollar 30%

Please help me how to aggregate or any other methods.

Thanks,

DavidFoster1 — Thu, 26 Sep 2013 15:16:19 GMT

Hi Venkata

In your example, the second table is not consistent with the first one. Also can you confirm the expression you are using for 'bad'?

CELAMBARASAN — Thu, 26 Sep 2013 15:17:01 GMT

Hi,

NO Name Field bad

11 tradelink dollar 10%

12 capital security 20%

131 tradelink dollar 20%

First row is NO field value is different. How come it have to merge in to single row?

venkatg6759 — Thu, 26 Sep 2013 15:23:54 GMT

sorry both the nos are same .I misstyped it . tradelink has only one no.

venkatg6759 — Thu, 26 Sep 2013 15:27:12 GMT

Hi David,

this is how we are doing %bad = sum{<field=>}bad/(sum({<field=>}bad+sum{<field=>good

We are having weights as well by which we calculate in this way

sum{<field=>}bad/(sum({<field=>}bad+sum{<field=>good * Weights