topic Re: Re: Re: Attach two Tables in QlikView

Attach two Tables

Wed, 07 May 2014 08:44:40 GMT

Hi,

I am trying to detach or attach a table.

I have 2 tables and 1 list box and In that my requirement is if i click on the list box only one table should change the other remain constant.Is there any way i can do it by using expression.

Re: Attach two Tables

Wed, 07 May 2014 08:45:32 GMT

Please try alternate states. First create the alternate state and then go to your list table and assign the alternate state.

Re: Attach two Tables

Wed, 07 May 2014 08:49:55 GMT

In the table which you want to remain constant, two things can be done:

1.Either right click and select detach.. In this case the table will remain constant irrespective of any selection.

2.Or add an expression someting like: Sum({$<[Listbox_field_name] =>}Sales)..... This will not refelect the change on the selection of that particular field only.

Re: Attach two Tables

Wed, 07 May 2014 09:19:46 GMT

Hi Srasthi,

Thanks for the reply.

I am attaching a file to the initial post.Can u suggest me accordingly.

I want Month Table to remain constant irrespective of making selection in other boxes.

Thanks

Ankit

Re: Re: Attach two Tables

ashfaq_haseeb — Wed, 07 May 2014 09:35:47 GMT

Hi,

Maybe like this.

See the attached.

Regards

ASHFAQ

Re: Attach two Tables

Wed, 07 May 2014 09:39:47 GMT

Hi Asfaq,

Yes this is what I wanted however can you explain me how to do it?

Thanks

Ankit

Re: Re: Attach two Tables

ashfaq_haseeb — Wed, 07 May 2014 09:50:04 GMT

Go to document properties --> General tab --> Click on alternate state and create a new state.

No to to your month chart --> General tab and from alternate state drop down select the state you created above.

Regards

ASHFAQ

Re: Re: Attach two Tables

Wed, 07 May 2014 09:57:32 GMT

Hi Ashfaq,

That really helped.

However is there any way that we can do it by Expression?

Thanks

Ankit

Re: Re: Re: Attach two Tables

ashfaq_haseeb — Wed, 07 May 2014 10:01:51 GMT

Hi,

May be like this.

See the attached

Regards

ASHFAQ

Re: Attach two Tables

Wed, 07 May 2014 10:10:08 GMT

Hi Ashfaq,

What if I select anything from the month(List Box), it should reflect changes to the month(Table).

Can we do it?

Thanks

Ankit

Re: Re: Attach two Tables

ashfaq_haseeb — Wed, 07 May 2014 10:23:42 GMT

Hi,

This should work.

=Sum({1<Month=p(Month),Month={"$(=Month(Max(Date)))"}>}Value)

Regards

ASHFAQ