topic Adding Field within Fields / SUMIF Bar Chart in QlikView

Adding Field within Fields / SUMIF Bar Chart

300sss300 — Mon, 16 Nov 2015 09:43:22 GMT

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

300sss300 — Mon, 16 Nov 2015 10:16:49 GMT

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

Anonymous — Mon, 16 Nov 2015 10:17:14 GMT

you can try sth like:

Take Name1, Name2 both as a dimension

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

300sss300 — Mon, 16 Nov 2015 10:21:52 GMT

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.