Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
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
PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
rustyfishbones
Master II
Master II
Author

I tried that already, it does nothing.

rustyfishbones
Master II
Master II
Author

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