topic Re: Set analysis with 2 set modifiers in QlikView

Set analysis with 2 set modifiers

marini — Wed, 25 Nov 2020 16:16:04 GMT

Hello everybody,

I'm new to the community and it has been just a few days I'm working with QlikView. I need to write a simple expression but I cannot find a way to make it work.

Hope you guys can give me a hand.

So we manage a few websites and what I need is: the number of users who have visited the website X at least 2 times (we call it sessions).

I have tried many ways and some of them give me the wrong number or 0. I really don't know what I've been doing wrong.

For instance, I tried:

=count({<[Account CODS Code] = {"=sum([Google Visit Sessions Counter]) > 1"}, [Google Website Url]={'https://xyz.com'}>} distinct [Account CODS Code] )

=count({<[Google Website Url]={'https://xyz.com'}, [Google Visit Sessions Counter]={">1"}>} distinct[Account CODS Code])

I can make it work if I use only one set modifier (example only those with >1 sessions or those who have visited the xyz.com website).

Could you guys please help me?

Thanks a lot!

Re: Set analysis with 2 set modifiers

sunny_talwar — Tue, 29 Jan 2019 14:45:04 GMT

Try one of these two

=Count({<[Account CODS Code] = {"=Sum({<[Google Website Url]={'https://xyz.com'}>} [Google Visit Sessions Counter]) > 1"}, [Google Website Url] = {'https://xyz.com'}>} DISTINCT [Account CODS Code])

=Count({<[Account CODS Code] = {"=Sum({<[Google Website Url]={'https://xyz.com'}>} [Google Visit Sessions Counter]) > 1"}>} DISTINCT [Account CODS Code])

Re: Set analysis with 2 set modifiers

marini — Tue, 29 Jan 2019 14:49:50 GMT

Wow! Both suggestions work!

Thank you so much for your (really) fast answer.