topic Re: line chart dimension in QlikView

line chart dimension

Fri, 31 Oct 2014 02:14:22 GMT

Hi there,

I want a line chart which shows the sum of net amount in buckets. Bucket values : 0-30,31-60,61+ days pending, over a year starting from today. What will be the dimensions for this attached sample chart?

Re: line chart dimension

Fri, 31 Oct 2014 02:37:49 GMT

Hi Jhansi Rani,

Try Calculated dimension like below:

=if(Bucket values>= 0 and Bucket values<=30, '0-30',

if(Bucket values>= 31 and Bucket values<=60, '31-60',

if(Bucket values>= 61,'61+days',Null())))

Check Suppress When value is Null

Expression:

Sum(Attribute Name)

I don't know that whats your exact attribute name in you data model. So try based on your attribute.

hope this helps you.

Best,

Robert

Re: line chart dimension

Fri, 31 Oct 2014 17:47:44 GMT

Hi there,

Yes, I need the buckets.I have fields like Net Amount, Age(eg:12, 45, 60 etc..) - Bucket , how can i get the week dimension(x- axis) (52 weeks starting from today)? Hope it is clear...

Re: line chart dimension

Mon, 03 Nov 2014 02:31:33 GMT

Hi,

Try like below:

Dimension 1 - Week

Dimension 2 -

=if(Age>= 0 and Age<=30, '0-30',if(Age>= 31 and Age<=60, '31-60',if(Age>= 61,'61+days',Null())))

Expression:

Sum([Net Amount])

Best

Robert

Re: line chart dimension

Mon, 03 Nov 2014 02:39:50 GMT

Hi Team,

Thank you for your support. As I dont have the reference date to calculate the week, i calculated based on ceil (age/7). I have the age bucket in my database. It resolved.Thank you for your time.