topic Re: Sum with distinct dimension in Load script in QlikView

Sum with distinct dimension in Load script

Thu, 17 Mar 2016 02:25:37 GMT

Is it possible to Calculate Sum with Distinct dimension in script?

Looking for a script function equivalent to =sum( Aggr([Sales Price ], LineItemId))

Thanks

sunny_talwar — Thu, 17 Mar 2016 10:54:00 GMT

You would do something like this:

LOAD LineItemId,

Sum([Sales Price]) as Sum

Resident XYZ

Group By LineItemId;

Chanty4u — Thu, 17 Mar 2016 10:58:29 GMT

create a filed as

sum([sales prcie]) as sum