topic Can't get not equal to work in QlikView

Can't get not equal to work

Fri, 25 May 2012 21:18:14 GMT

Hi Community,

Below I have some code that attempts to find the number of open tickets:

count(

{1<[Request Date Type] = {'Created'}>*<[Request Date Type]-={'Completed'}>}

[Request Date Type]

)

For some reason I get a little squigle under the -={"Completed">}... of the code and it gives me all the values created but not subtracting those that are completed.

Can't get not equal to work

Jason_Michaelides — Fri, 25 May 2012 22:43:37 GMT

Try:

count(

{1<[Request Date Type] = {'Created'}>*<[Request Date Type]={"='Completed'"}>}

[Request Date Type]

)

Re: Can't get not equal to work

vgutkovsky — Fri, 25 May 2012 23:20:30 GMT

Brandon,

Try set subtraction instead:

count({1<[Request Date Type] = {'Created'}>-<[Request Date Type]={'Completed'}>} [Request Date Type])

Vlad