Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

Need help with a Contiguity Chart

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.

Contiguity_Chart.png

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')

3 Replies
Highlighted

Re: Need help with a Contiguity Chart

Hi,

Tick below property

In dimension tab - > Supress when value is Null

and

in Presentation tab ->Supress zero value

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Master II
Master II

Re: Need help with a Contiguity Chart

I tried that already, it does nothing.

Highlighted
Master II
Master II

Re: Need help with a Contiguity Chart

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

contiguity1.png

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.

contiguity2.png