Sum of 3 conditions

[#1]

Good day,

I have in a table that contains these fields:

Equipment price

dc-1          40

dc-7          60

dc-14        15

dc-20        11

dc-7          21

z-5            40

dc-1          40

dc-14        15

I need an expression where all dc-1 + dc-20 + z-5 devices are added,

Amount of equipment = 4

Total price = 131

Thanks for your help.

[devarasu07]

Hi,

Try like below in your expression then u will get 131.

sum({<Equipment={'dc-1','dc-20','z-5'}>}price)

[maxgro]

sum({$ <Equipment={'dc-1','dc-20','z-5'}>} price) 

[sunny_talwar]

May be this

Sum({<Equipment = {'dc-1', 'dc-20', 'z-5'}>}price)

Count({<Equipment = {'dc-1', 'dc-20', 'z-5'}>}Equipment )

[#5]

Thank you very much for your answers.

I was able to give solution to my query.

[sunny_talwar]

Please close the thread by marking the correct answer.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny