Google analytics set expression

Wed, 10 Oct 2012 13:50:16 GMT

Hello!

I'm building a Qlikview to display some information from Google analytics, but I'm having some problems with a set expression.

I have the following fields that are relevant:

Data_dim_medium (this holds 'organic' for organic traffic and 'cpc' for paid traffic)

Data_date_qv (this holds the dates, for now 30 dates, 2012-09-01 through 2012-09-30)

Doublewords (A table containing all keywords that are present both as organic and paid, meaning people used these keywords to get to my site, but I also buy these keywords).

Data_metric_visits (number of visits to my site)

Now what I want is a list with Doublewords as dimension, showing organic visits when ads were off, and organic visists when ads are on.

Doublewords	Organic visits ad on	Organic visits ad off	Total organic visits	Total Paid visists
word1	12	13	25	15
word2	11	16	26	13
etc.

The below expression (Organic visists ad on) works if I select a specific word from the list Doublewords, but not as a pivot chart with doublewords as a dimension. What should I change?

Organic visists ad on:

=Sum({$<Data_dim_medium={'organic'},Data_date_qv=P({<Data_dim_medium={'cpc'}>}Data_date_qv)>}Data_metric_visits)

Total organic visists:

=SUM({<Data_dim_medium={'organic'}>} Data_metric_visists)

Total paid visists:

=SUM({<Data_dim_medium={'cpc'}>} Data_metric_visists)

Any advice would be greatly appreciated!

Thank you

Re: Google analytics set expression

Fri, 12 Oct 2012 06:50:38 GMT

So I figured out the problem, but still don't know how to solve it.

The set expression doesn't change over the dimension (probably obvious to some, but not to me )

I found some similar problems but can't seem to translate it into my specific issue.

http://community.qlik.com/message/226783

http://community.qlik.com/docs/DOC-1335

Re: Google analytics set expression

Anonymous — Wed, 17 Feb 2016 18:35:21 GMT

Hello,

I've found a way, if you want, you can see here:

http://bit.ly/1PQZ0Wj

Best Regards,

topic Google analytics set expression in QlikView

Google analytics set expression

Re: Google analytics set expression

Re: Google analytics set expression