How to create a join in the Qlikview Load statement?

Ask a Question

Hi All,

There are three tables, Users (which has user profile information), PageView count in Last Week and PageView Count in Last 4 Weeks.

I want to create a report for users who have Pageview Count

in last week >= 5

and

in last 4 weeks >= 15

This is how I created my report:

I have created two variables and input two boxes one for Last Week and one for Last foure weeks and associated them with relevant expressions in the table. Which is working and giveming me the data in or form. Like if PageCount in Last Week is 6 then in the PageCount in Last 4 Weeks is shown 0 (which is not possible...right?) How can I generalte report which show me the Users who have PageCount LastWeek >= 5 "and" Last 4Week >= 5

Your help will be highly appreciated.

Thanks,

0 Replies