topic How do I add a calcuation to set analysis? IF function? in QlikView

How do I add a calcuation to set analysis? IF function?

Thu, 25 May 2017 15:09:42 GMT

Hi All--

I am looking to use the below set analysis but also add a dimension using a date calc/IF function. I need to count a distinct number of pick up moves (PUP) if the (Stop Time - the Arrival time) is between -120 and 120 minutes.

I have the distinct part covered but I am unsure how to add the calculated part to it.

count(DISTINCT{$<[Stop Type] ={'PUP'}>}[TMW move#])

Thank you!

Jessica

Re: How do I add a calcuation to set analysis? IF function?

Anil_Babu_Samineni — Thu, 25 May 2017 16:35:08 GMT

I would suggest you to create in script like

Sample:

Load [stop time],

[arrival time],

If(Inteval([stop time] - [arrival time],'HH') >= '-120' and Inteval([stop time] - [arrival time],'HH') <= '120', 1, 0) as Flag,

[Stop Type],

[TMW move#]

From <Data Source>;

Sample:

Load [stop time],

[arrival time],

[Stop Type],

[TMW move#]

From <Data Source>;

Left Join (Sample)

Load *,

If(Inteval([stop time] - [arrival time],'HH') >= '-120' and Inteval([stop time] - [arrival time],'HH') <= '120', 1, 0) as Flag

Resident Sample;

Create Dimensions and expression like

Count({<[Stop Type] = {PUP}, Flag = {1}>} DISTINCT [TMW move#])

Re: How do I add a calcuation to set analysis? IF function?

sunny_talwar — Thu, 25 May 2017 16:59:55 GMT

May be this

Count(DISTINCT{$<[Stop Type] ={'PUP'}, [TMW move#] = {"=fabs([Stop Time] - [Arrival time]) <= MakeTime(2)"}>}[TMW move#])