topic Re: dinamic condition in dimention in QlikView

dinamic condition in dimention

Fri, 30 Nov 2012 12:30:57 GMT

Hi!

Please help if it possible.

I have expression:

=if(month = '201211',sum( TOTAL {<month={'201205'}>}Sale),0)

i need change month={'201205'} like this:

=if(month = '201211',sum( TOTAL {<month={month-6}>}Sale),0)

Is it possible to do someway?

Fri, 30 Nov 2012 12:55:47 GMT

Hi,

You can use Addmonths() function as follows:

=if(month = '201211',sum( TOTAL {<month={AddMonths(month,-6)}>}Sale),0)

Fri, 30 Nov 2012 13:05:58 GMT

Hi!

my "month" is not data field. it is string

Fri, 30 Nov 2012 13:09:25 GMT

Hi!

Unfortunatly it does't work.

My field is a srting.

Please see attachment

Fri, 30 Nov 2012 13:11:24 GMT

Hi,

Then convert string to date field using Date() and Date#() function, and use the expression stated above.

jonathan_dau — Fri, 30 Nov 2012 13:36:10 GMT

Hi,

Maybe you can use something like that :

sum( TOTAL {<month={">=$(=getfieldselections(month)-6)"}>}Sale)

Hope that helps

Jonathan

MayilVahanan — Fri, 30 Nov 2012 14:35:49 GMT

PFA

Mon, 03 Dec 2012 06:21:48 GMT

Thank you vrey much!