Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
' ' 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
Is this expression is correct??
One closing bracket is extra or one opening bracket is missed.
If so share the correct expression
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