topic Re: Date expression in QlikView

Date expression

upaliwije — Fri, 14 Feb 2014 09:52:29 GMT

I have 4 date fields in my data model

R_Year, R_month, To_Year, To_Month

When the use select R_Year and R_Month I want to calculate premium for To_Year= R_Year +1 and To_Month=R_Month where pol_type='F'

If R_Year=2013 and R_Month=1 result Should be To_Year=2014 and To_Month=1

I have written the following expression but it is not working. Can some one please look into this and rectify me.

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

Re: Date expression

Sokkorn — Fri, 14 Feb 2014 09:55:08 GMT

Maybe this one

Sum( {$<[To_YEAR] = {'$(=max([R_YEAR])+1)'},[To_MONTH]={'$(=max([R_MONTH]))'},POL_TYPE={'F'}>} [PREMIUM] )

Regards,

Sokkorn

Re: Date expression

jagan — Fri, 14 Feb 2014 09:58:31 GMT

Hi,

Try this expression

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

Regards,

Jagan.

Re: Date expression

manojkulkarni — Fri, 14 Feb 2014 10:08:20 GMT

use variables,

vMaxYear = max([R_YEAR])+1

vMaxMonth = max([R_MONTH])

sum( {<[To_YEAR] = {'$(vMaxYear'},[To_MONTH]={'$(vMaxMonth)'},POL_TYPE={'F'}>} [PREMIUM] )

Re: Date expression

upaliwije — Fri, 14 Feb 2014 10:17:21 GMT

Thanks It is still not working Pls help

Re: Date expression

upaliwije — Fri, 14 Feb 2014 10:17:56 GMT

It is still not working

Re: Date expression

upaliwije — Fri, 14 Feb 2014 10:29:21 GMT

This is not working

Re: Date expression

upaliwije — Fri, 14 Feb 2014 10:30:49 GMT

You expression is not working. But It works if delete To_Month Condtion

Re: Date expression

upaliwije — Fri, 14 Feb 2014 10:47:29 GMT

Thanks

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

This expression is not working But If I remove [To_MONTH]={'$(=max([R_MONTH]))'}, it is working but I don't get the desired result. The results shown is not limited to selected month. Pls help to solve this

Re: Date expression

jagan — Mon, 17 Feb 2014 05:18:31 GMT

Hi,

Can you attach some sample file?

Regards,

Jagan.

Re: Date expression

CELAMBARASAN — Mon, 17 Feb 2014 05:54:53 GMT

What are the values in To_MONTH and R_MONTH field?

How you calculated these two fields? Check whether you created with same logic.