Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

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

Hi

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.

1 Solution

Accepted Solutions
padmanabhan_ram
Contributor II

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

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

4 Replies
neetha_p
Honored Contributor

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

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

anbu1984
Honored Contributor III

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

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

padmanabhan_ram
Contributor II

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

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

yevgeniy
Contributor

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

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'}

Community Browser