topic Re: Filter in Alternate State in QlikView

Filter in Alternate State

retrocolor — Tue, 07 May 2013 06:38:33 GMT

Hi All,

I am new to alternate states. I have 2 filters - for example Country and Shop (one shop is in one country) and additional filter for Shop which is in alternate state (for ex. CompareShop). I need this filter to be in alt state but to depend on the selections only in Country filter (in default state). How can do that?

Thank you!

Radi

Re: Filter in Alternate State

kumarnatarajan — Tue, 07 May 2013 06:44:18 GMT

Hi,

you can able to use possible function.

Ref:

http://community.qlik.com/qlikviews/1194

Re: Filter in Alternate State

Gysbert_Wassenaar — Tue, 07 May 2013 06:51:00 GMT

You can add a Select in Field action to the OnSelect field event trigger of the Country field. Use Country as field to apply the selection in, use ='(' & concat(distinct Country, '|') & ')' as search string. Select the alternate state the CompareShop is in as Alternate State to apply the selection to.

Re: Filter in Alternate State

retrocolor — Tue, 07 May 2013 07:16:48 GMT

Hi,

This is interesting realization but it didn't help me.

Thank you!

Regards,

Radi

Re: Filter in Alternate State

kumarnatarajan — Tue, 07 May 2013 07:21:02 GMT

Hi ,

Ok Gysbert Wassenaar told method help full for you. else send me any sample file i can help you

Re: Filter in Alternate State

retrocolor — Tue, 07 May 2013 07:55:40 GMT

Hi,

Thank you! This works althought I am trying to escape all sort of triggering because most of the users use ajax.

I set OnSelect trigger and OnChange to clear the selection but if I have space in the value in doesn't select it. I tryed to add quote for each value (chr(39)) but it didn't help. Do you know how I can include these values?

I will post an example.

Regards,

Radi

Re: Filter in Alternate State

kumarnatarajan — Tue, 07 May 2013 08:02:02 GMT

Hi Radoslava Dimitrova,

Try This one,

EX: '(' & Concat(DISTINCT '"'&Country&'"','|') & ')'

quote for each value

Re: Filter in Alternate State

retrocolor — Tue, 07 May 2013 09:22:42 GMT

Hi,

Thank you all!

It works now.

Regards,

Radi

Re: Filter in Alternate State

Tue, 18 Jun 2013 09:12:01 GMT

Hello,

I am looking for exactly the same thing. I tried to apply your search string but I can't make it.

So in he file I attached u can see I have 2 times 2 fields

The first couple of fields are linked to alternate state 1 and the 1st chart.

The second couple of fields are linked to alternate state 2 and 2nd chart.

On product (alternate state 1) I made always one selected value so the user can select only one product.

So I think what I look for is similar to the previous post. When I select product N 1 in alternate state 1 it belongs to the category beauty. So I need that when I select product N 1 in alternate state 1 in the 2nd chart I have displayed all products from the category beauty.

Can u give me an example in the file attached?

Thank u

Re: Filter in Alternate State

Tue, 18 Jun 2013 09:15:29 GMT

Hello,

I am looking for exactly the same thing. I tried to apply your search string but I can't make it.

So in he file I attached u can see I have 2 times 2 fields

The first couple of fields are linked to alternate state 1 and the 1st chart.

The second couple of fields are linked to alternate state 2 and 2nd chart.

On product (alternate state 1) I made always one selected value so the user can select only one product.

Can u give me an example in the file attached?

Thank u

Re: Filter in Alternate State

retrocolor — Thu, 20 Jun 2013 06:36:53 GMT

Hello,

Here is the solution that I finally use .Unfortunately it could be heavy with big amount of data.

Regards,

Radi

Re: Filter in Alternate State

Thu, 20 Jun 2013 09:00:25 GMT

Thank u very much Radoslava !!! that is exactly what I look for!!!

Thank u all!