Button to select dimension based on value of multiple expressions

bullish35 — Tue, 07 Jun 2011 03:42:27 GMT

Hello,

I am displaying a straight table with a single dimension (Producer) and various expressions (including, Meetings, Interest, and Opportunity). I would like to do two things:

Set the background color, for the entire row, when Meetings=0 and Interest>0
Create a button that, when clicked, displays only the Producers with Meetings=0 and Interest>0

For simplicity's sake, I have uploaded an image displaying only the relavent expressions:

Meetings:

=count(distinct if([Meeting Type]='In-Person' and [Activity Type]='Meeting' and [Activity Cancelled]<>'Y',(Activity_ID)))

Interest:

=Column(3)+Column(4)+Column(5)

Opportunity:

=if(Column(12)>0 and Column(11)=0, 'Opportunity', '')

Your suggestions are greatly appreciated!

Thank you,

Ellen

Button to select dimension based on value of multiple expressions

rohit214 — Tue, 27 Sep 2011 05:50:53 GMT

hey Ellen,

for background colour

use:

if(meeting=0 and Interest>0 ,RGB(255,0,0))

and

sum({"1(if(meeting=0 and Invester>0)" },Producer)

may it helps you

regard

rohit

topic Button to select dimension based on value of multiple expressions in QlikView

Button to select dimension based on value of multiple expressions

Button to select dimension based on value of multiple expressions