Set Analysis to read a range based on condition

Anonymous — Wed, 06 Sep 2017 15:01:23 GMT

Hi all,

I want to use set analysis to sum up some quantities from certain files. I have 3 types of files that I load in my QVD in the following format (SourceFile):

LCCPSTAAAA

LCCACCAAAA

LCCREVAAAA

I would like Set Analysis to sum up only data from LCCPST* files and ignore the other 2. One way is to specify the exact name of the file but is there a way to just include a range based on a condition? In this case read everythign that starts with LCCPST. I have tried to use the following but it does not work:

Sum({$< Left(SourceFile,6) = {'LCCPST'}>} QTY )

Any help is appreciated.

Thanks.

Re: Set Analysis to read a range based on condition

sunny_talwar — Wed, 06 Sep 2017 15:15:26 GMT

Try this

Sum({$<SourceFile = {'LCCPST*'}>} QTY)

topic Set Analysis to read a range based on condition in QlikView

Set Analysis to read a range based on condition

Re: Set Analysis to read a range based on condition