Variables not working as expected .?

[ashmitp869]

Hi there,

The format of the variable is not working in Qlikview App.

I am using variables to work on the format , but still its holding the format even though anything is not selected.

Textbox Cohort1 expression = Num($(v_g1compmeasure1_expr),$(v_compmeasure1format))

First textbox with null value  =v_g1compmeasure1_expr

Second textboc holding the format variable = =v_compmeasure1_format.

The same variable worked it other Apps as expected like when not selected its showing null but in the app its showing Error : Error in expression because of the format. how to resolve the error message.

[ashmitp869]

Hi there,

How to check if getselectedcount(_compmeasure1)  then

Num($(v_g1compmeasure1_expr),$(v_compmeasure1_format))

else 

Null

[vinieme12]

can you post a screenshot of the entire expression editor window so we can see what the expression is evaluating to?

[ashmitp869]

Help me with the expression in text box :-

if GetSelectedCount is Null show "-"

else

Num($(v_g1compmeasure1_expr),$(v_compmeasure1_format))

I tried the below expression but not working -

=if(GetSelectedCount(_compmeasure1)=1,Num($(v_g1compmeasure1_expr),$(v_compmeasure1_format)))

[ashmitp869]

The problem I found is the variable v_compmeasure1_format is always '#,##0'.

But the other apps have three of them like below 

Thus its showing null as "-" . while when having only one format - it showing Error : Error in expression.

Any suggestion to get rid of the message Error : Error in expression and show "-" ?

[avinashelite]

Help attach the sample app , it would be easy to check . I don't see any issue with the expression need the check your app 

[vinieme12]

click on the below button(highlighted) and post a screenshot of sentire expression editor window

[ashmitp869]

[vinieme12]

can you post the full window of the expression editor, it shows the evaluated expression at the bottom of the editor

which is what i am after 

or as @avinashelite  suggested, post a sample app