Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Christoph,
I can't reproduce your issue here. Could you post a small sample QVW showing your issue?
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.
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
Christoph,
have you tried using the wildcard as suggested by Gysbert?
YES. Works like a charm!!! Thanks. Seemed i was too tired yesterday!!!!