Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
marini
Contributor
Contributor

Set analysis with 2 set modifiers

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!

1 Solution

Accepted Solutions
sunny_talwar

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])

View solution in original post

2 Replies
sunny_talwar

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])
marini
Contributor
Contributor
Author

Wow! Both suggestions work!

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