Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question on class function

Hi,

I would like to use the class function on a 'start time' field.

My problem is that I want only the start time related to a specific value signal and I want to know the occurence of another signal in that range.

The expression should be related to the occurence of another signal.

Something like this:

class(start_time of signal1,range) => expression: count(signal2).

I am not able to use set analysis on this....

Do you think that is feasible?

Thank you and regards,

Davide

3 Replies
Miguel_Angel_Baeyens

Hi Davide,

Check this thread to see whether this is what you are looking for.

Hope that helps.

Miguel

Not applicable
Author

Hi Miguel,

if I am not wrong the intervalmatch function can be used only inside the script.

The user should be able to dinamically select a delta to calculate the range of the interval.

Furthermore the interval is related only to the start_time of a specific signal (signal1) selected again by the user.

Regards,

Davide

Miguel_Angel_Baeyens

Hi Davide,

Intervalmatch() load can be used with as many fields as you need, but yes, this works in the script. You will need then to use a set analysis with a date range to count the number of occurrences of that event:

Count({< DateField = {">=$(vDateStart)<=$(vDateEnd)"} >} Event)

If you specify how your data looks it will be easier to get an appropriate answer.

Hope that helps.

Miguel