Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using the Qliksense Cookbook to learn how to create Highlighting the performance measure in a
bar chart in Qlik Sense.
I have followed all the instructions from page 67 till page 42, but the result I get not proper.
In my expression, it shows Error in expression.so I want Correct Expression;
Has anyone done this exercise too and got a good result? If so can that person help me?
I expect that there is a misplaced or missing parenthesis.
But its hard to debug this from an image. Please copy the expression as text and post that rather than an image.
Hi
I think your first IF abruptly closes before first '/sum(Budget)' which is not we want
Hi, as Jonathan saids, there is an additional parenthesis on the second row, RangeMin, there should be only 2 closing parenthesis before the '/'
I appreciate the solution given by you guys. I got a solution there is only one bracket missing as shown in the following pic .
Thank you
Same solution removing the closing one.
Rangemin returns only one value (like Sum), so there is no really need of parenthesis
It's actually, not missing of bracket, there's one extra bracket, remove that. Do one thing, place the cursor at: before the '(' or after the ')'. It'll highlight the relevant next/previous bracket where it's, Debug the complete measure like this. Then you could identify the extra bracket in the measure. In your expression, in the second line after Sum(Actuals), in the 3 brackets, remove one bracket. That'll resolve the issue.
Thank you Sir