topic Re: Using calculated dimension as a modifier in set expression in QlikView

Using calculated dimension as a modifier in set expression

Fri, 05 Sep 2014 03:58:22 GMT

Hi,

I need to use a calculated dimension like monthname(datefield) as a modifier in the set expression and equate it against

monthname(AddMonths(today(),-1)) in the set expression.Please let me know how this could acheived

Re: Using calculated dimension as a modifier in set expression

aveeeeeee7en — Fri, 05 Sep 2014 04:18:25 GMT

Try this:

Sum({<YourMonthnamefield = {"$(=monthname(addmonths(Today(),-1)))"},Year={'$(=Year(addmonths(Today(),-1)))'} >}Sales)

Regards

Aviral Nag

Re: Using calculated dimension as a modifier in set expression

Anonymous — Fri, 05 Sep 2014 04:30:50 GMT

Why not you create monthname(datefield) as MONTHNAME_DATEFIELD

at script level, NOw use this field as modifier to equate it against

monthname(AddMonths(today(),-1))

Re: Using calculated dimension as a modifier in set expression

Fri, 05 Sep 2014 06:09:23 GMT

Hi Nithin,

I understand that making it in the script would solve the issue.But, I would want to know if there is any other way to get this done

Re: Using calculated dimension as a modifier in set expression

Anonymous — Fri, 05 Sep 2014 06:29:26 GMT

No,

In set analysis, the modifier needs to be a Field name and not the calculation... or the variable....

Re: Using calculated dimension as a modifier in set expression

Fri, 05 Sep 2014 11:20:55 GMT

Hi Nithin,

so would it possible to declare the calculated dimension as a variable and use it in the set expression.I tried it but that does not seem to work

Re: Using calculated dimension as a modifier in set expression

jonathandienst — Fri, 05 Sep 2014 11:29:54 GMT

Putting the calculation in a variable makes no difference as the variable is expanded before the set expression is evaluated. So the set expression does not see the variable, it sees the calculation, and as you already know, that does not work.

HTH

Jonathan