topic Re: Adding Less than in an Expression in QlikView

Adding Less than in an Expression

nwilliams — Fri, 13 Jun 2014 09:42:41 GMT

Hi,

Its fair to say my visualisation skills are better than my scripting!!! I'm trying to add an expression to a text ox to show volume of calls under 180 seconds. The expression I wrote works with an "=" but when I change it to "<" it errors. Can anyone help?

Count (DISTINCT{<QueueInteractionsView.RRDisplayValue={'taken'},
[QueueInteractionsView.c_QueueGroup]={'Central Booking Desk'},
[QueueInteractionsView.QueueTime] < {'180'}
>} (lnk_InteractionId))

Re: Adding Less than in an Expression

MK_QSL — Fri, 13 Jun 2014 09:43:25 GMT

Count (DISTINCT{<QueueInteractionsView.RRDisplayValue={'taken'},
[QueueInteractionsView.c_QueueGroup]={'Central Booking Desk'},
[QueueInteractionsView.QueueTime] = {'<180'}
>} (lnk_InteractionId))

Count (DISTINCT{<QueueInteractionsView.RRDisplayValue={'taken'},
[QueueInteractionsView.c_QueueGroup]={'Central Booking Desk'},
[QueueInteractionsView.QueueTime] = {"<180"}
>} (lnk_InteractionId))

Re: Adding Less than in an Expression

Luis_Cortizo — Fri, 13 Jun 2014 09:44:21 GMT

Hi, Neil

Try with: [QueueInteractionsView.QueueTime] = {"<180"}

Hope it helps.

Best regards.

Re: Adding Less than in an Expression

nwilliams — Fri, 13 Jun 2014 09:45:13 GMT

So simple!!!!!

Thanks!!!