topic Help required in writing a expression. in QlikView

Help required in writing a expression.

Tue, 04 Jan 2011 13:45:56 GMT

Hi All,

Below expression should work as per the following requirement:

1. Should be locked for current month for the current year where the values of month in our application is like(m1,m2,...,m12). For your reference, From START_YEAR we are getting the year and from STARTPERIOD we are getting the month(m1,m2,...,m12).

2. Should be locked for year to date. For your reference, From START_YEAR we are getting the year and from STARTPERIOD we are getting the month(m1,m2,...,m12).


=ceil(sum(if(wildmatch(Category,'*Callcenter*') > 0 and (wildmatch([Agreement Achieved],'no')>0),1,0)) /

Hope you can help me out.

Note: Here month may create the problem as the values of the month are in (m1,m2,...,m12) and it is not like normal month(Jan-Dec) and also finding the max of month from these values (m1,m2,...,m12) is also a concern.

Thanks in advance. Please let me know once you get to know any solution.

Help required in writing a expression.

sathishkumar_go — Tue, 04 Jan 2011 14:30:15 GMT

Hi,

STARTPERIOD is which format? means date format or ???

and STARTPERIOD contains m1,m2...m12? like that or Jan,Feb.....Dec

or u have any date field in table?

possible attach ur application here for more helpful of finding the solution

-Sathish

Help required in writing a expression.

Tue, 04 Jan 2011 14:42:05 GMT

Thanks Sathish

START_YEAR contains only the year(YYYY).

STARTPERIOD contains only the periods which is as same as month but the values are like(m1,m2,....m12).

i,e. m1=jan,m2=feb,...m12=dec as per their understanding.

Sorry I cannnot attach the application. Please if you need anything else.

Help required in writing a expression.

sathishkumar_go — Tue, 04 Jan 2011 18:12:58 GMT

use purgechar(MonthTemp,'m') as MonthNo

then In MonthNo have 1 to 12. after that use max(MonthNo) u ll get max month also

-Sathish