Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

And condition between two Input boxes to show values in table

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.

0 Replies