topic Re: Variables not working as expected .? in App Development

Variables not working as expected .?

ashmitp869 — Tue, 20 Dec 2022 04:29:03 GMT

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.

Re: Variables not working as expected .?

ashmitp869 — Tue, 20 Dec 2022 04:55:12 GMT

Hi there,

How to check if getselectedcount(_compmeasure1) then

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

else

Null

Re: Variables not working as expected .?

vinieme12 — Tue, 20 Dec 2022 06:28:28 GMT

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

Re: Variables not working as expected .?

ashmitp869 — Tue, 20 Dec 2022 19:47:57 GMT

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

Re: Variables not working as expected .?

ashmitp869 — Tue, 20 Dec 2022 23:18:53 GMT

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 "-" ?

Re: Variables not working as expected .?

avinashelite — Wed, 21 Dec 2022 03:05:34 GMT

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

Re: Variables not working as expected .?

vinieme12 — Wed, 21 Dec 2022 03:12:01 GMT

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

Re: Variables not working as expected .?

ashmitp869 — Wed, 21 Dec 2022 04:35:02 GMT

Re: Variables not working as expected .?

vinieme12 — Wed, 21 Dec 2022 05:17:20 GMT

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