Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To find the sum containing a particular word

Hi

Greetings.

I need to find the sum of a group of values based on a certain word.The word can be either at the beginning/middle/at the end & it can be on upper and lower case too.In some cases the word will not be even present but they can be inside the same column header from the datasource(Excel its here -always)

Please find attached the sample data..

I want to find the sum of Quantity.

I tried using the following set expression

=sum({$<Assembly={"Display","DISPLAY","display"}>}[Quantity])

But it results in zero.

Kindly help in this regard

Regards

Senthil ! !

1 Reply
MK_QSL
MVP
MVP

You can do below trick...

create another DummyDisply field in script..

Load

  *,

  UPPER(Display) as DummyDisplay

Inline

[

  Display, Quantity

  Broken Display, 14

  Dust in Display, 15

  Impurities in Display, 22

  Broken, 12

];

Now use below set analysis function

=SUM({<DummyDisplay = {'*DISPLAY*'}>}Quantity)