Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Thanks for your answers
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');
This might help you
Partial Sums in straight table | Custom Labels in Pivot SubTotals
Might, but I do not have Qlik View...
can you post some sample data?
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
yes, but I can't load this image into Qlik sense to create a sample that you can refer too!!
Preparing examples for Upload - Reduction and Data Scrambling
How to get answers to your post?
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
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');
Thank you !