topic Re: Set analysis complex condition in modifier in QlikView

Set analysis complex condition in modifier

Tue, 14 Aug 2012 14:20:28 GMT

Hi all,

I was wondering if its possible to have a complex condition in modifier. For example I have a field RollingMonths which is of form "MMM-YYYY" (ex. 'May-2012') and I would like to create a comparision using current month and year. I've tried few different methods however none seem to work.

sum( {1<RollingMonth = {$(=date#(date(today),'MMM-YYYY'))}>} Units )

sum( {1<RollingMonth = {$(=month(today()) & '-' & year(today())))}>} Units )

I know the last option would be to create a variable.

Best regards,

Grif

Re: Set analysis complex condition in modifier

Anonymous — Tue, 14 Aug 2012 14:46:08 GMT

Grif,

Assuming that the RollingMonth field is text, your second expression should work with after a minor fix:

sum( {1<RollingMonth = {"$(=month(today()) & '-' & year(today()))"}>} Units )

I added quotes and removed extra ')'

If RollingMonth is numeric, your first expression maybe is closer to the correct one (except qoutes are missing and today has no '()') - but the exact syntax depends on how RollingMonth is defined.

Regards,

Michael

Re: Set analysis complex condition in modifier

Tue, 14 Aug 2012 14:54:38 GMT

Thank Michael,

I will try it and post my results.

Grif