topic Re: except two product in QlikView

except two product

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

Dear All

I Already use give below script to get a last year value in my script. But in this expression include all CLA_CODE (eg-; FR,MR,MS,TT,SS ,ect...) Then I want to get a value of except TT and MR CLA_CODE using with given below expression.

Please help me.

=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-10)'},DESCRIPTION= {'NRP'} >} [Budget])

sagara

Re: except two product

Chanty4u — Fri, 24 Feb 2017 04:40:53 GMT

you can include the expresion below in to your expression

CALCODE-={'VALUE1','VALUE2'}

Re: except two product

nagarjuna_kotha — Fri, 24 Feb 2017 05:02:23 GMT

Try this ,

It wil exclude those both and gives for remaining.

=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-10)'},DESCRIPTION= {'NRP'},CLA_CODE -={'TT','MR'} >} [Budget])

-Nagarjun

Re: except two product

sagaraperera — Fri, 24 Feb 2017 05:45:20 GMT

Dear Mr.Nagarjun

Thanks it is work

sagara

Re: except two product

nagarjuna_kotha — Fri, 24 Feb 2017 08:27:40 GMT

then kindly close this thread

-Nagarjun