topic Re: Date in set Expression in QlikView

Date in set Expression

upaliwije — Sat, 15 Feb 2014 08:24:36 GMT

Hi Friends

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

I have written the above expression in the attached file and it is working, But I want to modify it to show foolowing

When the use select R_Year as 2013 and R_Month as Jan

I want to show only records where To_Month<> R_Month (when R_Month=Jan then To_month= any month other than Jan)

In other words 1st 11 records shown in my my pivot table(attached) should be excluded and all other records must remain as it is

Please help me to rewrite the expression

Thanks

Gysbert_Wassenaar — Sat, 15 Feb 2014 08:47:37 GMT

This should do it: sum( {$<[To_MONTH]-={'$(=only([R_MONTH]))'},POL_TYPE={'F'}>} [PREMIUM] )

israrkhan — Sat, 15 Feb 2014 08:51:44 GMT

Hi Gysbert,

can you please comment on this post.

would be much appreciated...

Thanks...

upaliwije — Sat, 15 Feb 2014 09:01:09 GMT

Thanks a lot