topic Chart/Table Help in QlikView

Chart/Table Help

Thu, 19 May 2016 18:48:22 GMT

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 — Thu, 19 May 2016 18:55:34 GMT

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

swuehl — Thu, 19 May 2016 18:57:15 GMT

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

Thu, 19 May 2016 18:58:19 GMT

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 — Thu, 19 May 2016 18:58:22 GMT

Why do you expect 0-30 value to double?

swuehl — Thu, 19 May 2016 19:00:08 GMT

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

Thu, 19 May 2016 19:00:36 GMT

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.

Thu, 19 May 2016 19:11:56 GMT

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 — Thu, 19 May 2016 19:21:48 GMT

Can you try this:

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