Problems with Values in Brackets

[#1]

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

[swuehl]

Christoph,

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

[Gysbert_Wassenaar · Accepted solution]

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.

[#4]

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

[swuehl]

Christoph,

have you tried using the wildcard as  suggested by Gysbert?

[#6]

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