Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
cancel
Showing results for
Did you mean:
Not applicable

## Variable with parameter not working in expression

Dear Qlikers,

A newbie here trying to figure out why this simple statement wont work.

I have a simple expression:

=1-(Sum({1<Month ={'Oct-17'}>} Breaches))

/Sum({1<CalMonthYear2={'Oct-17'}>} Pathways)

which works fine.

--

Then in same expression I put a simple variable which is:

vTest = Oct-17

like so;

=1-(Sum({1<Month ={"\$(vTest)"}>} Breaches))

/Sum({1<CalMonthYear2={'Oct-17'}>} Pathways)

also works great

--

Then in same expression I put a slightly more complex variable which is:

vTest2  = Text(Month(Today())) & '-' & Text(right(Year(Today()),2))

(which outputs the same figure 'Oct-17' and works fine called from a text box) but in the expression

like so;

=1-(Sum({1<Month ={"\$(vTest2)"}>} Breaches))

/Sum({1<CalMonthYear2={'Oct-17'}>} Pathways)

but this only works if '=' is placed in front of formula in Variable Overview. Anyway it works so thats fine.

--

However I then have an even more complex function or 'parameter' variable which outputs exactly the same figure of 'Oct-17':

vTest3 =

if(\$1=0,

Text(Month(Today())) & '-' & Text(right(Year(Today()),2)),

& '-' &

if(

Text(right(Year(Today()),2))

)

)

works great in a normal text box but in the above expression i.e.

=1-(Sum({1<Month ={"\$(vTest3(0))"}>} Breaches))

/Sum({1<CalMonthYear2={'Oct-17'}>} Pathways)

this also refuses to work.

Can someone please help me as I'm pulling out my hair. I'm a sql guy and this is a little weird for me lol

Many thanks for your help in anticipation.

1 Solution

Accepted Solutions
MVP

This might explain the magic of the leading equal sign:

The Magic of Variables

Maybe try (without the leading equal sign variable definition)

=1-(Sum({1<Month ={"\$(=\$(vTest3(0)))"}>} Breaches))

/Sum({1<CalMonthYear2={'Oct-17'}>} Pathways)

2 Replies
MVP

This might explain the magic of the leading equal sign:

The Magic of Variables

Maybe try (without the leading equal sign variable definition)

=1-(Sum({1<Month ={"\$(=\$(vTest3(0)))"}>} Breaches))

/Sum({1<CalMonthYear2={'Oct-17'}>} Pathways)

Not applicable
Author

Actually Stefan,

As usual you are a genius. I had an extra '=' at the beginning of the formula in the Variable Overview where I assigned the formula, and that stopped it from working. Yes I re-read your post telling me to rid the equals sign there too duh.

Thank you so much

Community Browser