topic Need help with a Contiguity Chart in QlikView

Need help with a Contiguity Chart

rustyfishbones — Thu, 09 Mar 2017 11:28:05 GMT

Hi,

I have the following Chart. It show users activity by Minute for 1 day, some users have no activity and I want to remove these users from the chart.

I have 2 dimensions

OperativeName

OneMinuteBucket

And the following expression

NUM(

SUM(

Date = {"$(=MAX(Date))"},

[TrxType] = {'D'},

ActionID = {'PICKCASE'},

OneMinBucket = {"$(= '>=' & '07:30' & '<=' & '17:30')"}

$(metric2))

,'#,##0')

Re: Need help with a Contiguity Chart

PrashantSangle — Thu, 09 Mar 2017 11:44:03 GMT

Hi,

Tick below property

In dimension tab - > Supress when value is Null

and

in Presentation tab ->Supress zero value

Regards,

Re: Need help with a Contiguity Chart

rustyfishbones — Thu, 09 Mar 2017 11:50:24 GMT

I tried that already, it does nothing.

Re: Need help with a Contiguity Chart

rustyfishbones — Thu, 09 Mar 2017 12:01:14 GMT

I need to show the white spaces between the green and red bars, as the white space represents inactivity.

I have the bar expression =OneMinuteBucket and I get the correct bars with the inactivity minutes in white, but for all users

If I change this to 1, I only get the users that had activity (great!), but I then lose the inactivity minutes (white space between the bars) from the chart, which is what I want to show.