topic expression depending on selection in QlikView

expression depending on selection

Thu, 24 Feb 2011 17:00:18 GMT

Hi,

I have a dashboard with two expressions and I need to show one expression or the other depending on the selector.

Is it possible?

Thanks,

David

Thu, 24 Feb 2011 17:23:54 GMT

Of course. Are you making a selection in a field?

If(Only(SelectorField)="Value1", Sum(Expression1), Sum(Expression2))

There are many ways to do it. Using variables is good, because then everything comes from one place.

Thu, 24 Feb 2011 18:46:12 GMT

Hello,

There are two selectors, it doesn't depends on the value of the selector, only depends on the selector I use

Anonymous — Thu, 24 Feb 2011 19:08:53 GMT

if (getfieldselections ( field name ) , sum ( expression1 ) , sum (expression2 ) )

Thu, 24 Feb 2011 22:26:28 GMT

What do you mean by what selector? You mean there are two fields and you're only making a selection on one? Could you give an example?

Fri, 25 Feb 2011 13:24:21 GMT

thanks,

Both answers work perfectly

Fri, 18 Mar 2011 07:17:01 GMT

And without selecting the field, can I link it with another field in the layout?

ex: I have week and week2, some values are linked with week and others with week2 I need to unify this two fields,

I've tried to do it in the script calling both fields week but when I load a message of circular fields appears (I don't know why),

any idea?

Thanks,

David