Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Re: Need help on calculated dimensions

It is almost the same.

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

4 Replies
ananyaghosh
Creator III
Creator III

hi,

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

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

Anonymous
Not applicable
Author

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

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

ananyaghosh
Creator III
Creator III

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

Anonymous
Not applicable
Author

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.