Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
vvvvvvizard
Contributor III

Total in a Gauge chart

i have a straight table with the dimension Name :

expression 1 = Sum(A)

expression 2 = Sum(B)

expression 3 = Sum(C)

expression 4 = if(SumA>0,Sum(A),

                         if(SumA>0,Sum(B),

                          if(SumA>0,Sum(C))

  Now i need the get the total of expression 4 in a Gauge chart .

   to work out the total , for each "Name"  if it has a value in A add it to the total

                                                             if it has a value in B add it to the total

                                                             if it has a value in C only add it to the total if A or B has a value or 0 or is blank

Name cannot have a value in A and B at the same time

Name can have a value in  C and  either A or B at the same time

I couldnt upload my QVW so i just created a similar scenario with fake data , the Total CPU column total of 20 needs to match the total in the Gauge chart , thanks you .

Message was edited by: yusuf rawat

1 Solution

Accepted Solutions

Re: Total in a Gauge chart

you just need this to get a total of an expression in a text box object

Sum(Aggr(YourExpressionfromtheTable, YourDimensionIntheTable))

Using the above logic, this seems to work:

=Sum(Aggr(if(Sum(A)>0,sum(A),

if(Sum(B)>0 , sUM(B),

Sum(C))), Name))

7 Replies
MVP
MVP

Re: Total in a Gauge chart

sum(aggr(Sum(A)+Sum(B)+if(sum(A)=0 or Sum(B)=0, sum(C),0), Name))

Re: Total in a Gauge chart

Hi,


your expression

=if(SumA>0,Sum(A),if(SumA>0,Sum(B),if(SumA>0,Sum(C))

will only return Sum(A) if SumA>0, else it returns null.

Is this a typo?


please post sample data and expected result to clarify.

regards


Marco

MVP & Luminary
MVP & Luminary

Re: Total in a Gauge chart

Hi,

If you attached some sample data and your expected output then it would be easier to understand and provide the solution.  As per your explanation please find below expression

=Sum(Aggr(Sum(A) + Sum(B) + If(Sum(C) AND (Sum(A) > 0 OR Sum(B) >0), Sum(C),0), Name))


OR simply


=Sum(A) + Sum(B) + Sum(C) (AS you have mentioned that if it has a value in C only add it to the total if A or B has a value or 0 )


Hope this helps you.


Regards,

Jagan.



vvvvvvizard
Contributor III

Re: Total in a Gauge chart

That was a typo

=if(Sum(A])>0,Sum(A),

if(Sum(B)>0,Sum(B),

Sum(C)

))

vvvvvvizard
Contributor III

Re: Total in a Gauge chart

I have attached some sample data

MVP
MVP

Re: Total in a Gauge chart

sum

     (

     aggr(

          if(sum(A)>0,sum(A),

          if(sum(B)>0,sum(B),

          if(sum(A)=0 and sum(B)=0, sum(C)

          ))),

          Name)

     )

Re: Total in a Gauge chart

you just need this to get a total of an expression in a text box object

Sum(Aggr(YourExpressionfromtheTable, YourDimensionIntheTable))

Using the above logic, this seems to work:

=Sum(Aggr(if(Sum(A)>0,sum(A),

if(Sum(B)>0 , sUM(B),

Sum(C))), Name))