Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
300sss300
Creator
Creator

Adding Field within Fields / SUMIF Bar Chart

I have 3 Fields lets say Name1 Name2 and Amount. 

Q1) How I can add 4th field which is Name1 = Name2

Q2) I want to show in Bar Chart only those amounts If Name1=Name2. Expression in this case will be SUM (Amount)...... What will be the Dimention ??? 

Regards

1 Solution

Accepted Solutions
Anonymous
Not applicable

you can try sth like:

Take Name1, Name2 both as a dimension

Expreassion:  =sum(if(Name1=Name2, Amount))

View solution in original post

3 Replies
300sss300
Creator
Creator
Author

Already done with 2nd Question. Just need Ans for Q1.

Anonymous
Not applicable

you can try sth like:

Take Name1, Name2 both as a dimension

Expreassion:  =sum(if(Name1=Name2, Amount))

300sss300
Creator
Creator
Author

Thanks.

What about Q1.

I mean what if I want to set this condition "Name1=Name2"  as new field. Like Name1 Name2 and Amount so that there should be 4 fields.