topic Another beginner's question in QlikView

Another beginner's question

m4u — Sun, 27 Dec 2009 20:54:30 GMT

I am trying to make a simple debt aging chart.

I have a simple bar chart where the X axis is a calculated dimension - Today()-DueDate

The expression is Sum(LineTotal)

Basically, it shows me a bar for each possible value of the expression - which can be many values. I'd like to group those values into ranges - meaning to show 1 bar for all values for which the result the expression produces in between 0 and 30, another one for 31-60, 60-90 and 90+,

I know this can be done on the data loading level by adding a calculated field to the table itself... but can this be done as an expression of some sort, or another manipulation on the chart itself?

Another beginner's question

Sun, 27 Dec 2009 21:30:39 GMT

you could use the class function if your range is constant

example : class ( dimX , 30 , 'Value' )

You can also use If ( better if your range is not constant)

If ( dimX < 30 , '< 30' , if (dimX < 60 , '30 to 60' , if(dimX < 90 , '60 to 90' ,' > 90')))

Another beginner's question

Sun, 27 Dec 2009 21:52:20 GMT

You can have the chart dimension calculated as

=Class((Today()-DueDate),30,'Days')

This will return the X-axis dimension value grouped as '0<=Days<30, 31<=Days<60 .... and so on.

Let me know if this works

Tarique

Another beginner's question

m4u — Sun, 27 Dec 2009 21:57:12 GMT

Thanks guys