Set analysis + sum qty with type start with 'AB' and 'CD'

jim_chan — Thu, 26 Jan 2017 13:02:39 GMT

Hi guys,

a simple one i guess.

I want to create a set analysis - sum of qty but only type of start with AB and CD. In my data now, i have these data 'AB_qwwertwr' and 'CD_zxbcmsjkf'.

Can this work???

sum(if(left(<MASTERHIS_PRD_CD,2)='AB' or left(MASTERHIS_PRD_CD,2)='',TRFIN_QTY))

Re: Set analysis + sum qty with type start with 'AB' and 'CD'

sunny_talwar — Thu, 26 Jan 2017 13:05:39 GMT

Try this:

Sum({<MASTERHIS_PRD_CD = {'AB*', 'CD*'}>} TRFIN_QTY)

topic Set analysis + sum qty with type start with 'AB' and 'CD' in QlikView

Set analysis + sum qty with type start with 'AB' and 'CD'

Re: Set analysis + sum qty with type start with 'AB' and 'CD'