Discussion board where members can get started with Qlik Sense.
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
Go to Solution.
May be try like this
LOAD * INLINE [
LOAD 'XXX' as Name,
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
Now use D_Name in your Dimensions
Thank you !