Define new value from dimension

[pavanqlik]

Hi Folks,     I am having below requirement where i had a column in fact table name for ex: ABC where the rows have below  

abc	Value
x	10
y	20
z	30

My ask is to get new row with name ZZ and it should have value as sum(x+y) i.e 10+20 = 30.

abc	Value
x	10
y	20
z	30
zz	30

How can i achieve this. Thanks,

[jensmunnichs]

This looks like one of those posts where someone tries to simplify their requirement because they don't want to share their actual data. Understandable, but that makes it pretty difficult to actually help you. What is the logic behind your requirement? Why do those 2 values need to be added together and not the value for z? Right now I could give you the below solution, which does result in what you say you are looking for, but I feel like it might not be quite what you want.

Data:
LOAD * Inline [
abc, Value
x, 10
y, 20
z, 30];

Concatenate (Data)

LOAD 'zz' as abc, Sum(Value) as Value
Resident Data
Where abc = 'x' or abc = 'y';

Unless of course you can somehow apply the above solution to your data, which would be great 🙂

[Brett_Bleess]

The other thing I wanted to post for you is a link to the Community Design Blog area which contains hundreds of posts from our experts regarding different topics.  Something there might help you as well.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

That takes you directly to the place you can enter your search criteria.

Regards,
Brett