topic Question on class function in QlikView

Question on class function

Mon, 05 Dec 2011 10:26:17 GMT

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

Question on class function

Miguel_Angel_Baeyens — Mon, 05 Dec 2011 10:53:46 GMT

Hi Davide,

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

Hope that helps.

Miguel

Question on class function

Mon, 05 Dec 2011 11:05:51 GMT

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

Re: Question on class function

Miguel_Angel_Baeyens — Mon, 05 Dec 2011 11:14:00 GMT

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