topic total-function in script? in QlikView

total-function in script?

Mon, 01 Aug 2011 12:09:38 GMT

Hi everybody,

I'm using the total-function in pivot tables, for example:

sum(Sales)/sum(total <District> Sales).

My question ist now, is there any possibility for the total-function for using in the script? I need to calculate a solution like this in the script.

Thanks

vicky

rahulgupta — Mon, 01 Aug 2011 12:43:10 GMT

Hey Hi,

Temp:

Load SalesPerson,

District,

Sales

From Table;

Left Join

Load District,

Sum(Sales) as DistictSales

From Table

Group By District;

TempFinal:

Load Name,

District,

sum(Sales)/Sum(DistrictSales)

Resident Temp

Group By Name,District;

Hope this helps...

Regards

Mon, 01 Aug 2011 13:47:10 GMT

Thanks. It helps! I only hope before, that there is an easier way, but now I have my result

regards

vicky