topic Re: Fabs total issue in QlikView

Fabs total issue

bharani8 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts - in the attached qv file.. I have created an expression which says Column B value Column A values... By the use of "Fabs" function i got all the expression values in positive.. But now i need the Total of all the values which came from my fab function..

I.e., in the attached example .. Total of my Expression should be 200 where as it shows only 40.. Please Help!

Re: Fabs total issue

Anil_Babu_Samineni — Mon, 11 Sep 2017 10:29:20 GMT

May be this?

Sum(Aggr(Fabs(sum(B)-Sum(A)), A, B))

Re: Fabs total issue

Frank_Hartmann — Mon, 11 Sep 2017 10:29:57 GMT

expression tab, Total Mode --> Sum of Rows

Re: Fabs total issue

Anil_Babu_Samineni — Mon, 11 Sep 2017 10:31:33 GMT

This option is not available in pivot table

Re: Fabs total issue

Frank_Hartmann — Mon, 11 Sep 2017 10:33:50 GMT

i used his sample. where is he mentioning using pivot?

Re: Fabs total issue

Anil_Babu_Samineni — Mon, 11 Sep 2017 10:35:21 GMT

What if Pivot?

Re: Fabs total issue

Frank_Hartmann — Mon, 11 Sep 2017 10:36:29 GMT

thats not the question.

in his example he is using straight table

Re: Fabs total issue

bharani8 — Mon, 11 Sep 2017 11:01:27 GMT

Hi Anil.. I used your Formulae... But i see some wrong calculation happening here.. Chk the highlighted one..

Re: Fabs total issue

bharani8 — Mon, 11 Sep 2017 11:05:14 GMT

TY!..I need the number to be appearing in Text box as well..

Re: Fabs total issue

Anil_Babu_Samineni — Mon, 11 Sep 2017 11:06:52 GMT

What expression you used in real data? I assume, you have only one Dimension so with in the aggregation you can use Only one dimension

Re: Fabs total issue

bharani8 — Mon, 11 Sep 2017 11:08:57 GMT

Yes.. I have only 1 Dimension and 3 Expression..

Re: Fabs total issue

Frank_Hartmann — Mon, 11 Sep 2017 11:09:55 GMT

=sum(aggr(fabs(sum(B)-Sum(A)),A,B))

Re: Fabs total issue

Anil_Babu_Samineni — Mon, 11 Sep 2017 11:10:27 GMT

Can you share updated work file

Re: Fabs total issue

bharani8 — Mon, 11 Sep 2017 11:11:39 GMT

Sorry... in Agg function.. i didnt use Dimension.. i used my Expression .. Now working fine

Re: Fabs total issue

Anil_Babu_Samineni — Mon, 11 Sep 2017 11:12:21 GMT

Good

Re: Fabs total issue

bharani8 — Tue, 12 Sep 2017 06:50:35 GMT

Hi Anil... When i click on particular month.. i see right number.. but if more than a month is selected.. number seem to be wrong..

any idea ?

Re: Fabs total issue

Anil_Babu_Samineni — Tue, 12 Sep 2017 07:10:30 GMT

May be you can try this?

Only({<Month>} Sum(Aggr(Fabs(sum({<Month>}B)-Sum({<Month>}A)), A, B)))

If(GetFieldSelections(Month) >=1,Sum(Aggr(Fabs(sum(B)-Sum(A)), A, B)), Fabs(Sum(B)-Sum(A)))

Re: Fabs total issue

bharani8 — Tue, 12 Sep 2017 07:46:08 GMT

Not working

Re: Fabs total issue

Anil_Babu_Samineni — Tue, 12 Sep 2017 07:55:32 GMT

please share updated workfile ?

Re: Fabs total issue

bharani8 — Tue, 12 Sep 2017 08:07:15 GMT

Only({<Month>} Sum(Aggr(Fabs(sum({<Month>}B)-Sum({<Month>}A)), A, B)))

Above one is showin as wrong expression