Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I can use FABS function in a straight table, however when I use it in a text object it does not return the correct result.
FABS(SUM({<TaskId = {'*ADJUST*'}>}[#Act-Second]))
Any ideas why it aint correct in the text object but its ok in the table, should I be removing the null values.
Regards
Alan
May be try this
Sum({<TaskId = {'*ADJUST*'}>} Fabs([#Act-Second]))
or this
Sum(Aggr(fabs(Sum({<TaskId = {'*ADJUST*'}>} [#Act-Second])), ChartDimensions))
May be try this
Sum({<TaskId = {'*ADJUST*'}>} Fabs([#Act-Second]))
or this
Sum(Aggr(fabs(Sum({<TaskId = {'*ADJUST*'}>} [#Act-Second])), ChartDimensions))
ok, this works, but I need a better way
=FABS(SUM({<TaskId = {'*ADJUST*'}, [#Act-Second] = {">0"}>}[#Act-Second]))
+ FABS(SUM({<TaskId = {'*ADJUST*'}, [#Act-Second] = {"<0"}>}[#Act-Second]))
First one worked thanks
I think the problem is the single quotes in the set expression.
Single quotes means exact value. Use double quotes to make a search.
FABS(SUM({<TaskId = {"*ADJUST*"}>}[#Act-Second]))
See the blogpost https://community.qlik.com/blogs/qlikviewdesignblog/2017/09/11/quotes-in-set-analysis