Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

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

' ' 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

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

Is this expression is correct??

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

If so share the correct expression

sasikanth
Valued Contributor III

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

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

Community Browser