Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Help required in writing a expression.

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.

3 Replies
Partner
Partner

Help required in writing a expression.

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

Not applicable

Help required in writing a expression.

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.

Partner
Partner

Help required in writing a expression.

HI

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