App Development

Discuss and learn more about Qlik Sense app development and usage.

Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

Who Me Too'd this topic

rlewkowicz
Contributor
Contributor

Dynamic time series chart filtering based on input field

Hi,

I'm having problems with writing a chart measurement expression for time series object.

- There is an input field, where I can put numerical values.

- There is a table which is filtered only to values which have crossed the threshold defined in an input field (let's call this table a "Violations Table").

- There is a multiple traces time series chart which is supposed to only display objects which HAVE CROSSED THE THRESHOLD AT LEAST ONCE during the loaded time frame.

INPUT DATA:
Object,Value, Time
eth0, 1, 081220201200
eth1, 1, 081220201200
eth0, 1, 081220201201
eth1, 3, 081220201201
eth0, 2, 081220201202
eth1, 5, 081220201202

INPUT FIELD EXAMPLE VALUE:
4

DESIRED OUTCOME:

Violations Table(only single probe have crossed the threshold value from input field):
Object,Value, Time
eth1, 5, 081220201202

Time Series Chart (only eth1 is displayed, because eth0 have never crossed the value "4" from input field and eth1 have crossed it at least once):
eth1, 1, 081220201200
eth1, 3, 081220201201
eth1, 5, 081220201202

 

The question is: how do I write measurement function for time series chart to achieve such thing? Only thing I have come up with was filtering only to crossed values, but in this case I want to present the whole Object time series if at least one of it's values have crossed the threshold. Of course, if several objects have crossed the threshold value at least once, all of them should be displayed. Keep in mind that the input box is a dynamic field which can be changed directly from user perspective and all the charts should be rendered again everytime this field is updated.

Thank you for your help!


Regards,
Rafal

Labels (3)
Who Me Too'd this topic