Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum in table

Hi All

I have this data:

in a table.I want to set an expression to have this result:

A -> 6 (sum of all Number with Period=A)

C -> 4 (sum of all Number with Period=C)

B -> 50 (sum of all Number with Period=B)

and so on..

How can I set the sum() ? Aggr ( sum (Distinct Number), Period) doesn't work..

Thanks

luca

4 Replies
lironbaram
Partner
Partner

you should build a table

with period as the dimension and sum(Number) as the expression

cfz
Employee
Employee

Hi Luca,

The easiest way is to use a pivot table and do a simple sum as in the example. Otherwise in order to be able to help you I would nee to know how the table needs to look like, that, is with dimensions must be present and where in the table the different results 6, 4, 50 need to appear. A screenshot of the desired table would be great to avoid misunderstanding.

Kind regards

Carlos

Not applicable
Author

Thanks Liron.

I'va already build a table, but doesn't work. The field Type does not allow a simple sum (Number)..

sujeetsingh
Master III
Master III

See this sample