Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of 3 conditions

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.

5 Replies
devarasu07
Master II
Master II

Hi,

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

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

maxgro
MVP
MVP

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

1.jpg

sunny_talwar

May be this

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

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

Not applicable
Author

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