Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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
MVP & Luminary
MVP & Luminary

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

Christoph,

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

MVP & Luminary
MVP & Luminary

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

Not applicable

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

MVP
MVP

Christoph,

have you tried using the wildcard as  suggested by Gysbert?

Not applicable

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