topic Gauge Chart Issue in QlikView

Gauge Chart Issue

Wed, 07 Apr 2010 12:10:49 GMT

Hi All,

Please refer attached test.QVW.

Issue is getting for PRG -> HQ

APP-> SIC

Gauge chart is giving error message.

Data is shown in Gauge chart on the basis of TS_PCT and BG_PCT.

Please see TS_PCT data for this combination. There are 3 records for this combination and for all the 3 records ' TS_PCT data value is 1. If i change any one records TS_PCT value other than 1, issue will get resolve. But i am not allowed to change this data manually.

Please tell me how can i rectify this error. Please help me urgently.

Thanks in advance.

Gauge Chart Issue

deepakk — Wed, 07 Apr 2010 12:31:58 GMT

Just change the "and" to "or"

isNull(TS_PCT)=-1 and isNull(BG_PCT)=-1,

isNull(TS_PCT)=-1 or isNull(BG_PCT)=-1,

I hope this helps u

Gauge Chart Issue

Wed, 07 Apr 2010 13:03:56 GMT

It is not working Deepak.

Please help me on this it is very urgent.

Gauge Chart Issue

deepakk — Wed, 07 Apr 2010 13:10:42 GMT

use SUM like below everywhere

sum(TS_PCT) < .75 and sum(BG_PCT)

you are writing (TS_PCT) < .75 and (BG_PCT) which i feel is wrong...!!!

Gauge Chart Issue

Thu, 08 Apr 2010 10:08:30 GMT

Thank you so much it is working fine.

Can you tell me the reason why we need to use sum(TS_PCT) < .75 and sum(BG_PCT) instead of (TS_PCT) < .75 and (BG_PCT) ?

Gauge Chart Issue

deepakk — Sun, 11 Apr 2010 06:46:21 GMT

When you have multiple values in you column eg: if you have customer who has purchased 3 items..

Item Amt

A 100

B 200

C 200

Then if you wnat to see his total sales which is the combincation of these three articles you have to use sum. SImilarly in your case TS_PCT had multiple values hence you have to use some aggr function to get a proper value.