Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

total-function in script?

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

2 Replies
rahulgupta
Partner - Creator III
Partner - Creator III

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    

Not applicable
Author

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

regards

vicky