Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum of Attributes

Hi all,

I have a problem:

I have attributes EEE and FFF in Column Name and I would like to show two thinks:

1.) I want to show attribute XXX as Sum of EEE and FFF

     This sum is solved by this code: if(Name='EEE' or Name='FFF', 'XXX', Name) as Name

     So I see only XXX, BUT:

2.) I want to show also EEE and FFF attributes as before

So, I would like to show table as below:

snap.PNG

Thanks for your answers

1 Solution

Accepted Solutions
sunny_talwar

May be try like this

Table:

LOAD * INLINE [

    Name, Total

    AAA, 18737

    BBB, 17556

    CCC, 274242

    DDD, 46279

    EEE, 10596

    FFF, 1241699

    GGG, 139449

    HHH, 479850

    JJJ, 45065

];

Concatenate (Table)

LOAD 'XXX' as Name,

Total

Resident Table

Where Match(Name, 'EEE', 'FFF');

Capture.PNG

View solution in original post

12 Replies
vinieme12
Champion III
Champion III

This might help you

Partial Sums in straight table | Custom Labels in Pivot SubTotals

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Might, but I do not have Qlik View...

vinieme12
Champion III
Champion III

can you post some sample data?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Dataset is this table, but I have only EEE and FFF records, but I want to XXX as sum and show also EEE and FFF, nothing more

vinieme12
Champion III
Champion III

yes, but I can't load this image into Qlik sense to create a sample that you can refer too!!

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

Preparing examples for Upload - Reduction and Data Scrambling

How to get answers to your post?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

Here is a what you need to do

FACT:

LOAD * INLINE [

Name,Pass,Fail

A,1,1

B,1,1

C,1,1

D,1,1

E,1,1

F,1,1

];

DisplayNAMES:

D_Name,Name

A,A

B,B

C,C

D,D

E,E

F,F

X,E

X,F

];

Now use D_Name in your Dimensions

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

May be try like this

Table:

LOAD * INLINE [

    Name, Total

    AAA, 18737

    BBB, 17556

    CCC, 274242

    DDD, 46279

    EEE, 10596

    FFF, 1241699

    GGG, 139449

    HHH, 479850

    JJJ, 45065

];

Concatenate (Table)

LOAD 'XXX' as Name,

Total

Resident Table

Where Match(Name, 'EEE', 'FFF');

Capture.PNG

Anonymous
Not applicable
Author

Thank you !