topic Re: Need help on calculated dimensions in QlikView

Re: Need help on calculated dimensions

Anonymous — Mon, 11 May 2015 12:23:59 GMT

It is almost the same.

See attached. You can select years in the list box and see how the chart changes.

ananyaghosh — Mon, 11 May 2015 15:02:40 GMT

hi,

Can u explain, what is the requirement of " " (double quote) in the expression:

sum({<Year={"$(='>=' & (max(Year)-1) & '<=' & max(Year))"}>} Income)

Anonymous — Mon, 11 May 2015 15:11:36 GMT

In this case it is for expression ($-sign expansion) in the set modifier:

{"$(=<expression is here>)")}

ananyaghosh — Mon, 11 May 2015 15:42:06 GMT

I know that it is a set expression, but if I did not use double quote what will happen?

Anonymous — Mon, 11 May 2015 15:53:53 GMT

It still may work if you replace double quotes with the single quotes here - but it doesn't have to. See this: QlikView Quoteology

I recommend to use double quotes in the cases like that.

Without any quotes - I don't expect it to work.