topic Alternative State - show not selcted in default in QlikView

Alternative State - show not selcted in default

Fri, 10 Oct 2014 14:11:13 GMT

Hi,

I have default state and alternative state.

Both have same filters and same tablebox with raw data.

Is there any way to display records in alternative tablebox, that wasn't displayed already in default state?

Re: Alternative State - show not selcted in default

Fri, 10 Oct 2014 14:34:34 GMT

Hi,

See the attached QVW.

I have created a variable vProduct and check the trigger in DocumentProperties -> Triggers -> Select for Product field click onselect and see the expression.(image attached)

Thanks,

Shruthi Reddy

Re: Alternative State - show not selcted in default

Fri, 10 Oct 2014 14:44:13 GMT

Thanks but probably I've explained it a little bit wrong.

I need to see in table records, that wasn't selected in default state.

E.G

Default State

I'm choosing Svc3 I have 3 possible Products: 3,7,10.

I'm choosing Prod 7 and only 1 row is in TB01.

Alternative State.

I'm choosing Svc3 I have 3 possible Products: 3,7,10. TB03 have 3 rows for those pair.

And I want only to have 2 rows in TB02. All except pair 3 and 7, because I have them in TB01.