topic Re: FABS in set analysis in QlikView

FABS in set analysis

krish2459 — Sat, 16 Nov 2024 18:21:11 GMT

Hi,

Please me with the logic .

Requirement: Pareto graph

Where to use FABS in below expression.

expression1:

num(Sum({<Year=, Quarter=, Month=, Week=, [Pstng Date]={">=$(=Date(Max( [Pstng Date])-13))<=$(=Date(Max( [Pstng Date])))"}>} [Posting Amount] ),'##.##0')

expression2:

RangeSum(Above(Sum({<Year=, Quarter=, Month=, Week=, [Pstng Date]={">=$(=Date(Max( [Pstng Date])-13))<=$(=Date(Max( [Pstng Date])))"}>} [Posting Amount] ), 0, RowNo()))
/
Sum({<Year=, Quarter=, Month=, Week=, [Pstng Date]={">=$(=Date(Max( [Pstng Date])-13))<=$(=Date(Max( [Pstng Date])))"}>} total [Posting Amount] )

If possible please add an logic for soring also.

Thanks,

Kishore

Re: FABS in set analysis

krish2459 — Thu, 16 Jul 2020 19:03:07 GMT

Any inputs please.

Thanks..

Re: FABS in set analysis

sunny_talwar — Thu, 16 Jul 2020 19:11:35 GMT

usage of fabs will depend on what you want to see... fabs and then sum or sum and then fabs. For example, if this is my data

-4

Do you want to see 2 fabs(Sum(Value)) or 6 Sum(fabs(Value))

Re: FABS in set analysis

krish2459 — Thu, 16 Jul 2020 19:38:02 GMT

I want to make -10,-20,-30 as 10,20,30

Re: FABS in set analysis

sunny_talwar — Thu, 16 Jul 2020 19:44:28 GMT

But is that at the row level or summed up level?

Re: FABS in set analysis

krish2459 — Thu, 16 Jul 2020 19:55:50 GMT

In data it self they were posting as Negative.

Thanks...

Re: FABS in set analysis

krish2459 — Thu, 16 Jul 2020 20:46:33 GMT

Yes it is row level.

Re: FABS in set analysis

sunny_talwar — Fri, 17 Jul 2020 11:22:22 GMT

Then should work

Num(Sum({<Year, Quarter, Month, Week, [Pstng Date] = {">=$(=Date(Max([Pstng Date])-13))<=$(=Date(Max([Pstng Date])))"}>} fabs([Posting Amount])), '##.##0')