topic Re: not equal in set expression in QlikView

not equal in set expression

upaliwije — Thu, 13 Jul 2017 15:50:01 GMT

I have following expression which is working fine

sum( {<R_YEAR=,R_MONTH=,[R_MONTH]= {$(=concat([R_MONTH],','))},[R_YEAR] = {$(=max([R_YEAR]+1))},POL_TYPE={'R'}>} [PREMIUM] )

But one I modify it in the following way it does not work

sum( {<R_YEAR=,R_MONTH=,[R_MONTH]-= {$(=concat([R_MONTH],','))},[R_YEAR] = {$(=max([R_YEAR]+1))},POL_TYPE={'R'}>} [PREMIUM] )

Pls help me write it correctly

Re: not equal in set expression

vishsaggi — Thu, 13 Jul 2017 15:57:38 GMT

Are you getting any error or not getting any values?

Re: not equal in set expression

kaushiknsolanki — Thu, 13 Jul 2017 15:59:13 GMT

Try this.

sum( {<[R_MONTH]-= {$(=concat([R_MONTH],','))},[R_YEAR] = {$(=max([R_YEAR]+1))},POL_TYPE={'R'}>} [PREMIUM] )

Regards,

Kaushik Solanki

Re: not equal in set expression

antoniotiman — Thu, 13 Jul 2017 16:00:28 GMT

Hi,

Try to add DISTINCT in Concat

or instead try this

R_MONTH=E(R_MONTH)

Regards,

Antonio

Re: not equal in set expression

upaliwije — Thu, 13 Jul 2017 16:04:42 GMT

I do not get any value

Re: not equal in set expression

upaliwije — Thu, 13 Jul 2017 16:05:08 GMT

Still the Value is 0

Re: not equal in set expression

vishsaggi — Thu, 13 Jul 2017 16:18:14 GMT

Referring to Kaushik and Antonio's expression try this ?

= sum({< [R_YEAR] = { "$(=max([R_YEAR])+1)" }, [R_MONTH] = E([R_MONTH]), POL_TYPE={'R'}>} [PREMIUM])

Re: not equal in set expression

upaliwije — Thu, 13 Jul 2017 16:29:16 GMT

It give a value but amount is wrong.

1st column shows my original expression 2nd one shows as per your expression. value in 2 nd column should an amount less than 1st column. pls help

Re: not equal in set expression

sunny_talwar — Thu, 13 Jul 2017 16:32:10 GMT

Would you be able to explain in words about what you are trying to do here?

Re: not equal in set expression

upaliwije — Fri, 14 Jul 2017 03:18:11 GMT

Thanks Sunny,

What I want is the following. In my first Column I showed all the Premium renewed for the particular month (Renewal Date relates to same month). In the second column I want to show the Premium renewed in that particular month of which renewal date does not fall into that particular month Eg Premium Renewed in June but should have been renewed in May. R_Month is the relevant month

Re: not equal in set expression

upaliwije — Fri, 14 Jul 2017 11:21:35 GMT

Dear Friends

Could you pls help me to rectify my expression

Re: not equal in set expression

kaushiknsolanki — Fri, 14 Jul 2017 11:24:14 GMT

Is there any selection you are doing which will impact the calculation?

If yes then those needs to be neglected in the set analysis I gave you.

Regards,

Kaushik Solanki