topic How to show all non-unique dimensions with Sum Expression in QlikView

How to show all non-unique dimensions with Sum Expression

Wed, 03 Dec 2014 03:11:17 GMT

Hello guys, I have a problem.

This is my Data Table

Then I want it shows as:

Without showing the Seq Column.

I know it's weird to do this, but I need it to shows up like this.

I appreciate any kind of help, thanks.

Gysbert_Wassenaar — Wed, 03 Dec 2014 10:20:43 GMT

In the UI you can create a straight table with simply Description as dimension and sum(Amount) as expression.

In the script you can create that summary table like this:

DataTable:

LOAD Seq, Description, Amount

FROM ...source...;

Summary:

LOAD Description, sum(Amount) as SumOfAmount

Resident DataTable

GROUP BY Description;

rubenmarin — Wed, 03 Dec 2014 11:01:46 GMT

Hi Daniel, You can make a conditional dimension like: =Dual(Description, Seq)