topic Re: Set analysis help: equal to and not equal to at the same time. in QlikView

Set analysis help: equal to and not equal to at the same time.

Mon, 26 Jan 2026 18:19:17 GMT

I am trying to add to this expression which works. It counts the service desk tickets if there is a identical ticket number in time tracker. But I want it to count those and even if there is no identical ticket number in time tracker.

Here is my code: =count(DISTINCT{<TimeTracker.RequestType={SR}>} if(ServiceDesk.CallRequestNum=TimeTracker.RequestNum,ServiceDesk.CallRequestNum))

How can I make it do both in this expression? Is there a way to say equal to and not equal to?

Thanks,

Alam.

Re: Set analysis help: equal to and not equal to at the same time.

Anonymous — Mon, 22 Dec 2014 20:14:27 GMT

Hi,

For equal to(=)

=count({<TimeTracker.RequestType={SR},ServiceDesk.CallRequestNum = {TimeTracker.RequestNum}>}DISTINCT TimeTracker.RequestType)

For not equal to(-=)

=count({<TimeTracker.RequestType -={SR},ServiceDesk.CallRequestNum -= {TimeTracker.RequestNum}>}DISTINCT TimeTracker.RequestType)

Regards

Neetha

Re: Set analysis help: equal to and not equal to at the same time.

anbu1984 — Tue, 23 Dec 2014 05:35:40 GMT

=count(DISTINCT{<TimeTracker.RequestType={SR}>} ServiceDesk.CallRequestNum)

Re: Set analysis help: equal to and not equal to at the same time.

padmanabhan_ram — Tue, 23 Dec 2014 06:39:28 GMT

HI,

How are the Time Tracker and Service Desk tables are related to each other. Are they linked using the Request Number from both the tables. If yes, then you can use

Count(Distinct {<TimeTracker.RequestType={SR}>} ServiceDesk.CallRequestNum)

Thanks

Padmanabhan

Re: Set analysis help: equal to and not equal to at the same time.

yevgeniy — Tue, 23 Dec 2014 09:22:58 GMT

Hi,

your write:

Is there a way to say equal to and not equal to?

=count(DISTINCT{<TimeTracker.RequestType={SR}>} ................

not equal try this:

TimeTracker.RequestType={'<>SR'}