Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AD24
Contributor
Contributor

Sum Aggregation in Table based on specific dimension

Hello Team,

Is it possible to perform sum aggregation over a specific dimension in a table?

The objective is to add this as a measure in two tables. Measure : Price *Qty

Table 1 : With Material field - dimension for aggregation

AD24_0-1624780534184.png

 

Table 2: Without material field added in the table but still the total remains same as table 1

AD24_1-1624780574963.png

 

1 Reply
PrashantSangle

Something like this

PrashantSangle_0-1624800296689.png

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.