topic Table Help in QlikView

Table Help

Anonymous — Wed, 03 Jun 2015 21:11:34 GMT

Hello,

I ran into a curious issue, and looking for the best way to handle. I created a pivot table, that allows to show by year and % basis. When I do not select a year, the table shows about 1/2 the true percentage. When I select one of the years, it returns the proper amount. Picture below:

Here is my expression:

Sum ({<[CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [LINE OF BUSINESS]={'HOME'}, [MONTH-TEXT]=, [CLAIM SYM GROUP SMG]=-{'N/A'}, [DATA ORIGIN]={'SMG BY COV'}>}[AY INCURRED W ALAE])

/Sum ({< [CAT IND]={'N'}, [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [LINE OF BUSINESS]={'HOME'}, [CLAIM SYM GROUP SMG]={'BLANK'} , [MONTH-TEXT]=, [DATA ORIGIN]={'SMG BY COV'}>} total [DIRECT EARNED PREMIUM])

Looking for some thoughts to the best way to show the percentage properly over the two years.

Thanks for the help,

Justin

Re: Table Help

stigchel — Wed, 03 Jun 2015 21:17:33 GMT

Can you try with

Re: Table Help

swuehl — Wed, 03 Jun 2015 21:19:27 GMT

Try

.... total<Year> [DIRECT EARNED PREMIUM])

Re: Table Help

Anonymous — Thu, 04 Jun 2015 13:03:57 GMT

Perfect, thank you for the help!

Justin