Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try like below in your expression then u will get 131.
sum({<Equipment={'dc-1','dc-20','z-5'}>}price)
sum({$ <Equipment={'dc-1','dc-20','z-5'}>} price)
May be this
Sum({<Equipment = {'dc-1', 'dc-20', 'z-5'}>}price)
Count({<Equipment = {'dc-1', 'dc-20', 'z-5'}>}Equipment )
Thank you very much for your answers.
I was able to give solution to my query.
Please close the thread by marking the correct answer.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny