Set Analysis Query in Gauge Chart

Wed, 02 Dec 2015 08:49:48 GMT

Hi All,

I have a demo table like below. Now I have a list box that shows month based on KPIDate as Jan, Feb etc. I have taken a gauge chart and want to display a number (style LED format).

KPIDate	Claim_TTL	Count	Claim
201501	1	1	200
201501	0	1	300
201501	0	1	400
201501	1	1	500
201502	1	1	600
201502	1	1	700
201502	0	1	800
201502	0	1	900
201503	0	1	1000
201503	1	1	1100
201503	1	1	1200
201504	1	1	1300
201504	0	1	1400
201504	0	1	1500

I have a requirement to show count when a month is selected, only where Claim_TTL is 1. So if Jan is selected, then it should show the below

KPIDate	Claim_TTL	Count	Claim
201501	1	1	200
201501	1	1	500

I am writing this expression in the gauge chart expression

Sum({<Claim_TTL= {1}} Count)

But this always return 0. Can you please help me with this expression? Basically I want to show the count here which will be 2 in Jan case.

Re: Set Analysis Query in Gauge Chart

eduardo_sommer — Wed, 02 Dec 2015 17:16:30 GMT

There is a > missing in your expression

Sum({<Claim_TTL= {1}>} Count)

Eduardo

Re: Set Analysis Query in Gauge Chart

Thu, 03 Dec 2015 01:02:40 GMT

Thanks Eduardo. Fixed it.

Set Analysis has very confusing expression language.

topic Re: Set Analysis Query in Gauge Chart in QlikView

Set Analysis Query in Gauge Chart

Re: Set Analysis Query in Gauge Chart

Re: Set Analysis Query in Gauge Chart