Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is meaning this ' ' (symbol) in Expressions ?

HI ,

IN qlikview examples documents  use this  ' ' symbol in expressions ple explain me what is the meaning and how to work this ' ' symbol in qlikview ? ple tell me out . i do not understand 'symbol (' ') in expressions.

example:

Sum ({<Year = {$(=Max(Year))}>}Actual * PL_Flag) + Sum({<Year = {$(=Max(Year))}, Month = {$(=Month(vTodaysDate))}>}[Closing Amount] * BS_Flag), ' ' )


thank you




Regards:

Madhu

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

' ' means blank (a space) but in your expression it doesn' mean anything, probably your full expression is

If( ....., Sum ({<Year = {$(=Max(Year))}>}Actual * PL_Flag) + Sum({<Year = {$(=Max(Year))}, Month = {$(=Month(vTodaysDate))}>}[Closing Amount] * BS_Flag), ' ' )


in this case  the ' ' means that if condition is not valid show a blank

Not applicable
Author

Is this expression is correct??

One closing bracket is extra or one opening bracket is missed.

If so share the correct expression

sasikanth
Master
Master

hi

That not a specific one ,

if you want you can use anything like null(), or what ever you want

thats an Else condition part , if the condtion is not satisfied then it will go to else part