topic Re: Script Wise Sum in QlikView

Script Wise Sum

NavinReddy — Sun, 28 Apr 2013 17:13:06 GMT

Hi All,

How Can we done Script wise Sum ,i know about the Dashboard we can able to apply sum function

Plz explain me how can we do in Script wise

Thanks in Advance

Niranjan

Re: Script Wise Sum

sivarajs — Mon, 29 Apr 2013 05:47:57 GMT

Sum aggregates towards dimension in chart ,while in sciprt we need to use group by field name for the aggregation

Load sum(sales)

from table.qvd group by ID;

If you are loading all the fields while summing you need to give all the fields in group by function.

So it better you always calculate in seperate load and field you are going to aggregate like the above example.

Re: Script Wise Sum

NavinReddy — Mon, 29 Apr 2013 07:30:01 GMT

Hi Sivaraj ,

Thanks a lot its helpful for me

Thanks & Regards

Niranjan

Re: Script Wise Sum

NavinReddy — Mon, 29 Apr 2013 08:33:58 GMT

Hi Sivaraj ,

I tried but example is not working will you please give

any other example

Thanks in Advace

Niranjan

Re: Script Wise Sum

amars — Mon, 29 Apr 2013 10:29:41 GMT

Hi Niranjan,

Write it in this way,

Load ID, sum(sales)

from table.qvd group by ID;

so the above will give sum for each ID,

If you do not have any Group by Clause , u can simply write,

Load sum(sales) from table.qvd ;

For more please see the file attached

Amar

Re: Script Wise Sum

sivarajs — Mon, 29 Apr 2013 11:27:16 GMT

Check the attached file

Re: Script Wise Sum

NavinReddy — Mon, 29 Apr 2013 11:33:29 GMT

Hi amars,

Thank you very much its working fine,nice explanation amars

Thanks & Regards

Niranjan

Re: Script Wise Sum

NavinReddy — Mon, 29 Apr 2013 12:09:29 GMT

Hi Sivaraj,

yes it is also working fine,great job

thank you so much

Thanks & Regards

Niranjan