topic Re: connecting expression in QlikView

connecting expression

sagaraperera — Fri, 26 Feb 2016 04:43:50 GMT

Dear All

I try to get a last year figure in my script given using given below expressins

sum( {$<TRAN_YEAR= {"$(=Only([TRAN_YEAR]-1))"}>} [Actual])

It is 100% work,

But i want to hard cord get a figure only GROSS_PREMIUM. I use get a current year GROSS_PREMIUM given below expression

Sum ( {$<DESCRIPTION= {'GROSS_PREMIUM'} >}[Actual])

I WANT CONECT ABOVE TWO EXPRESSION AND GET A LAST YEAR GROSS_PREMIUM ONLY.

Please help me.

Sagara

Re: connecting expression

Chanty4u — Fri, 26 Feb 2016 04:46:27 GMT

=sum( {$<TRAN_YEAR= {"$(=Only([TRAN_YEAR]-1))"} and DESCRIPTION= {'GROSS_PREMIUM'} >} [Actual]) )

Re: connecting expression

tresB — Fri, 26 Feb 2016 04:46:53 GMT

sum( {$<DESCRIPTION= {'GROSS_PREMIUM'}, TRAN_YEAR= {"$(=Only([TRAN_YEAR])-1)"}>} [Actual])

Re: connecting expression

tresB — Fri, 26 Feb 2016 04:47:48 GMT

Your 'and' is improper here. It should be replaced by a comma (,).

Re: connecting expression

Anonymous — Fri, 26 Feb 2016 04:59:10 GMT

may be like this?

=sum( {<TRAN_YEAR= {'$(=Only([TRAN_YEAR]-1))'},DESCRIPTION= {'GROSS_PREMIUM'}>} [Actual])

=sum( {<TRAN_YEAR= {'$(=max([TRAN_YEAR])-1)'},DESCRIPTION= {'GROSS_PREMIUM'}>} [Actual])

and check this as well, helpful for you?

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Re: connecting expression

Anonymous — Fri, 26 Feb 2016 05:02:20 GMT

sum( {$<DESCRIPTION= {'GROSS_PREMIUM'}, TRAN_YEAR= {"$(=Only([TRAN_YEAR]-1))"}>} [Actual])

Re: connecting expression

Digvijay_Singh — Fri, 26 Feb 2016 05:08:28 GMT

Just wanted to know the use of 'only' here, I think its not making sense here, may be I am missing something..

Re: connecting expression

Anonymous — Fri, 26 Feb 2016 05:14:11 GMT

sum( {<TRAN_YEAR= {'$(=Only([TRAN_YEAR])-1)'},DESCRIPTION= {'GROSS_PREMIUM'}>} [Actual])

-1 is given the outside of the braces

Re: connecting expression

tresB — Fri, 26 Feb 2016 05:15:31 GMT

Yes it would even work similarly without the function only(). It's that - to tell explicitly that the expression would work only on - single value selection of Year field TRAN_YEAR.

Re: connecting expression

Fri, 26 Feb 2016 05:30:13 GMT

PLEASE TRY THIS EXPRESSION.

sum( {$<TRAN_YEAR= {'$(=max([TRAN_YEAR])-1)'}, DESCRIPTION ={'GROSS_PREMIUM'}>} [Actual])

Re: connecting expression

jagan — Fri, 26 Feb 2016 05:36:54 GMT

Hi,

Try like this

sum( {$<DESCRIPTION= {'GROSS_PREMIUM'} , TRAN_YEAR= {"$(=Only([TRAN_YEAR]-1))"}>} [Actual])

It is always better to use Max(TRAN_YEAR) in set analysis instead of ONly. If you have multiple possible values your expression fails to calculate.

sum( {$<DESCRIPTION= {'GROSS_PREMIUM'} , TRAN_YEAR= {"$(=Max([TRAN_YEAR]-1))"}>} [Actual])

Hope this helps you.

Regards,

jagan.