Chart/Table Help

[#1]

How can I get this data (currently in a pivot):

Into this type of view?

I want a view that has only one row, not all the additional null lines.

[sunny_talwar]

May be use TOTAL Qualifier here with if statement. What is the expression you are using right now?

[swuehl]

Please post the dimensions and expressions you are using. Also a table view might be helpful.

[#4]

The expression is Sum(Invoice Balance Amount)

That's the problem isn't it? It showing me three different sums. How can I get Qlik to roll them up onto one line?

[swuehl]

Why do you expect 0-30 value to double?

[swuehl]

Try to use only Division as dimension and all other number columns as expressions using aggregation functions.

[#7]

The dimensions are :

*Division, Current,0-30, 60-90, 90-120, Over 120

I only have one expression:

Sum(Invoice Balance Amount)

I just want it all to roll up onto a single line view.

[#8]

Ok- I did that but here is what I end up with:

It wont calculate correctly. Here is the formula for Current:

If(DaysBetween<=30,Sum([Invoice Balance]))

Days between has been defined as the difference between due date and today.

[sunny_talwar]

Can you try this:

If(Len(Trim(Current)) > 0, Sum(TOTAL <Division> [Invoice Balance Amount]))