topic Problems with Values in Brackets in QlikView

Problems with Values in Brackets

Tue, 23 Jul 2013 17:10:37 GMT

Hey everyone,

i have a problem with calculating a formula:

it works with

sum(if(source='cpc',unique_visitor))

but it doenst work with the source and the value "(direct)".

sum(if(source='(direct)',unique_visitor))

I think the problem might be that the value is in brackets but i have no idea how to change it.

Best

Christoph

Re: Problems with Values in Brackets

swuehl — Tue, 23 Jul 2013 17:18:40 GMT

Christoph,

I can't reproduce your issue here. Could you post a small sample QVW showing your issue?

Re: Problems with Values in Brackets

Gysbert_Wassenaar — Tue, 23 Jul 2013 17:19:46 GMT

Try sum({<source={'*(direct)'}>}unique_visitor). And make sure to use the exact case sensitive field names as Qlikview is case sensitive in most places.

Re: Problems with Values in Brackets

Tue, 23 Jul 2013 21:22:54 GMT

Hey i am sorry. I was posting the wrong part:

Count({<medium = {'(direct)'},order_status_id = {"2","5"}>} order_id)

In this case the (direct) doenst work. Its not calculating anything. If i use

Count({<medium = {'cpc'},order_status_id = {"2","5"}>} order_id)

it works fine!

Thanks

Re: Problems with Values in Brackets

swuehl — Wed, 24 Jul 2013 00:34:38 GMT

Christoph,

have you tried using the wildcard as suggested by Gysbert?

Re: Problems with Values in Brackets

Wed, 24 Jul 2013 07:24:22 GMT

YES. Works like a charm!!! Thanks. Seemed i was too tired yesterday!!!!