topic Re: Expression Formula Error in QlikView

Expression Formula Error

Anonymous — Tue, 05 Jan 2016 22:16:40 GMT

I am trying to use this formula in a expression, while i try and do that I get a error. The main purpose of the formula is to "flag the field if it is >.75 with a 1, and if it is less than .75 by a 0. Please let me know if there is a easier way to do this

=if(sum({<Reporting_Period_Num ={"$(=max(Reporting_Period_Num))"}, {$<[CDU LOS] = {'*'}>} CDU_Percent)

and

sum({<Reporting_Period_Num ={"$(=max(Reporting_Period_Num)-1)"}, {$<[CDU LOS] = {'*'}>} CDU_Percent)>= .75 ,'1','0')

Please help Scholars

Note: Edited by moderator for title brevity.

Re: Expression Formula Error

Peter_Cammaert — Tue, 05 Jan 2016 23:20:11 GMT

If you are trying to flag the sum(Percentage) for current period + sum(Percentage) for previous period as being larger than 75%, replace the and between the two sums by a +. There are a few superfluous braces and other characters as well (you don't have to specify sets inside sets). To fix this, remove the {$< characters in both sum() calls (that's probably the reason why you're getting an expression error).

If my first assumption is correct, your expression now looks like:

=if(sum({<Reporting_Period_Num ={"$(=max(Reporting_Period_Num))"}, [CDU LOS] = {'*'}>} CDU_Percent)

sum({<Reporting_Period_Num ={"$(=max(Reporting_Period_Num)-1)"}, [CDU LOS] = {'*'}>} CDU_Percent)>= .75 ,1,0)

Note: when getting expression errors, always start by checking the proper balancing of parentheses, braces, squarze brackets and the lot. Might save you a lot of time and effort! The syntax checker will even help you with finding missing markers. Place your cursor immediately before a brace or parenthesis. It will be underlined by a colored stripe (usually orange). The corresponding brace or parenthesis will be underlined as well. If not, the syntax checker will make a guess as to where it should be, and mark the remainder of the expression as faulty using "red wiggly lines".

Best,

Peter

Re: Expression Formula Error

Anonymous — Tue, 09 Aug 2016 16:46:30 GMT

thank you.