Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems with Values in Brackets

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


1 Solution

Accepted Solutions
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
swuehl
MVP
MVP

Christoph,

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

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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
MVP
MVP

Christoph,

have you tried using the wildcard as  suggested by Gysbert?

Not applicable
Author

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