Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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])
or
=Count({<[Account CODS Code] = {"=Sum({<[Google Website Url]={'https://xyz.com'}>} [Google Visit Sessions Counter]) > 1"}>} DISTINCT [Account CODS Code])
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])
or
=Count({<[Account CODS Code] = {"=Sum({<[Google Website Url]={'https://xyz.com'}>} [Google Visit Sessions Counter]) > 1"}>} DISTINCT [Account CODS Code])
Wow! Both suggestions work!
Thank you so much for your (really) fast answer.