topic Re: Set Expression in QlikView

Set Expression

upaliwije — Sat, 15 Jul 2017 08:36:27 GMT

I have attached my QV document where you find two pivot tables in my below shown table I want to show under the column "premium renewed rating to other month" premium renewed that do not fall into current month.

I want to show Rs.19728 in last column that this the amount relating to 1st policy no highlighted in yellow where pol period to ens in April but not in may . Pls help me

Re: Set Expression

upaliwije — Sat, 15 Jul 2017 11:39:00 GMT

Hi Friends

Pls help me with solution for my problem

Re: Set Expression

upaliwije — Tue, 18 Jul 2017 11:09:49 GMT

My Friends

Any feedback to my above discussion is welcome

Re: Set Expression

Anil_Babu_Samineni — Tue, 18 Jul 2017 11:47:32 GMT

Like this?

I am considering as Month(POL_PERIOD_FROM) = Month(POL_PERIOD_TO) with in the set analysis

Re: Set Expression

upaliwije — Tue, 18 Jul 2017 15:39:41 GMT

Thanks Anil,

Could you please attached the modified QV Document

Re: Set Expression

upaliwije — Wed, 19 Jul 2017 03:25:32 GMT

If I modify the expression as you said it does not work

Below is my new set expression

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