topic Re: Reduce column-width for linear guage? in QlikView

Reduce column-width for linear guage?

jrdunson — Wed, 10 Sep 2014 18:00:42 GMT

Hey, how do I reduce the column width for a linear gauge? I've tried RTrim, LTrim, even changing my load script?

Re: Reduce column-width for linear guage?

ashfaq_haseeb — Wed, 10 Sep 2014 18:28:42 GMT

Hi,

Can you attach sample application

Regards

ASHFAQ

Re: Reduce column-width for linear guage?

jrdunson — Thu, 11 Sep 2014 14:00:54 GMT

Ashfaq,

I'm not sure how to do this...our tables have 921K rows...I'll have to create some fake data...and that might take a while...

I'll try

Re: Reduce column-width for linear guage?

ecolomer — Thu, 11 Sep 2014 14:04:00 GMT

Can try push Ctrl+Caps and move elements

Re: Reduce column-width for linear guage?

Anonymous — Thu, 11 Sep 2014 14:05:13 GMT

are there any negative values in your 921k rows?
(it Looks like that as I had the same behaviour)

try to make two Charts one for positive for for negative values

Re: Reduce column-width for linear guage?

jrdunson — Thu, 11 Sep 2014 14:10:07 GMT

Enrique, I tried Ctrl_Caps...it doesn't do anything...

I think it has to do with leaving space, for negative amounts...? from -1 to 0 ? I'm only showing values from 0 to 1:

My Dimension is: Division

My Expressions

1. Sum ([Gifts Amount])

2. Sum([Gifts Amount]) / Max(Total Aggr(Sum([Gifts Amount]), [Gifts Division]))

- this follows Stephen Redmond's Cookbook... only, his example does have the wide Guage column...

Re: Reduce column-width for linear guage?

jrdunson — Thu, 11 Sep 2014 14:16:26 GMT

Hey, I did some research and did find some negative amounts... so hm, not sure how to deal with this

Re: Reduce column-width for linear guage?

ecolomer — Thu, 11 Sep 2014 14:20:39 GMT

Yes probably if you have negative elements the space is reserved for

Re: Reduce column-width for linear guage?

ecolomer — Thu, 11 Sep 2014 14:22:07 GMT

For Caps+Ctrl you need table active

Re: Reduce column-width for linear guage?

jrdunson — Thu, 11 Sep 2014 15:02:00 GMT

Tried to add set analysis to eliminate values less than zero:

From

Sum([Gifts Amount]) / Max(Total Aggr(Sum([Gifts Amount]), [Gifts Division]))

To:

Sum({$< [Gifts Amount] = {">=0"} >}[Gifts Amount] ) / Max(Total Aggr(Sum({$< [Gifts Amount] = {">=0"} >}[Gifts Amount] ), [Gifts Division]))

But my chart was unaffected .. will keep trying

Re: Reduce column-width for linear guage?

ecolomer — Thu, 11 Sep 2014 15:03:42 GMT

To try put fabs function to have only positive numbers