And condition between two Input boxes to show values in table

Fri, 07 Sep 2012 17:19:23 GMT

Hi All,

Here is my senario:

I have three tables (which I have attached as spreedsheet with this questions)

Pageview Last Week

Pagewiewed last 4 weeks and

Users

I want to create a list of user and to show the count of page viewed against name and id

which fulfill the following conditions

Pageview count in last week >= 5 and

Pageview count in last 4 weeks >=16 for example

The way I am trying to handle it as created two variable and input boxes and then used these two variables in expression

Variable 1 for sum page count in last week and

Variable 1 for sum page count in last 4 weeks

and the expressions are

SUM ({<PAGEVIEW_COUNT_Lastweek={">$(Variable1)"}>}PAGEVIEW_COUNT_Lastweek)

and

SUM ({<PAGEVIEW_COUNT_last4weeks={">$(Variable2)"}>}PAGEVIEW_COUNT_last4weeks)

When I use only variable and expression I get the right result but when I use both I dont.

Again I need user list along with actual page counts in last week and last 4 weeks who fulfill both conditions

Plese help, I would be greatful.

Thanks,

Excel sheets are attahced.

topic And condition between two Input boxes to show values in table in QlikView