Solved: Re: Alternate states with a common column - Qlik Community

Anonymous · ‎2017-03-10

I have 3 tables Products ,Customer and shops

Shops table is the connecting Products and Customers in data model.I am displaying Products details in one sheet and Customer details in other sheet with alternate states enabled but I want Shop_Name column(Used as filter in both sheets) from shop table to effect both the sheets commonly .How to implement this

CarlosAMonroy · ‎2017-03-14

Ok, that's fair.

So, what comes to my mind is the following:

Go to Settings -> Document Properties, under Triggers tab, section Field Event Triggers, add an 'OnSelect' action.

The action should be a selection type:

Select in field = Shop_Name and Searching String = =Shop_Name.

Then create another action with the same parameters but the trick is in the Alternate State selection, by choosing Product.

Here is the Screenshot.

Now when you select a shop, will be selected on both sheets.

Thanks,

Carlos

View solution in original post

Anonymous · ‎2017-03-11

build a listbox for [Shop_Name column] in "$-State" and change your expression(s) in the following way

sum( { [YOUR_ALTERNATE_STATE] <[Shop_Name column]=$::[Shop_Name column]>} yourvalue)

Then all fields besides [Shop_Name column] are in [YOUR_ALTERNATE_STATE]

Anonymous · ‎2017-03-13

I am using Shop_Name Column on both the sheets,Using your logic,if Shop_Name filter is selected on one sheet ,other sheet Shop_Name filter is just hiding non matching rows.

CarlosAMonroy · ‎2017-03-13

Hi Krishna,

If you can share a sample file, that would be great. For me make sense what Robin suggested you but it's not for you.

Thanks,

Carlos

Anonymous · ‎2017-03-13

please prepare a small example...

Anonymous · ‎2017-03-13

Please find the sample file attached.I want the shop_Name column to work commonly on both the sheets

tresesco · ‎2017-03-14

In the Product sheet use state <default state> for Shop Name field both in table and listbox.

CarlosAMonroy · ‎2017-03-14

Hi Krishna,

I'm not sure if I completely understand your request. Please help me understand what you need.

Alternate states performs comparative analysis between sets of multiple data items.

Now what is your approach, if you leave both sheets in the default state and you select any values from the shop filter, you'll see both sheets are affected by the selections you made.

The next link may be helpful. How to use Visual Cues and Alternate States in QlikView?

Thanks,

Carlos

Anonymous · ‎2017-03-14

Hi Carlos,

I am trying to use Alternate states in little Hacky way .I just want two alternate states objects to respond for a single common filter.In my case that filter is Shop name and I want to place that filter on both the sheets.Apart from Shop name filter ,two sheets have their own filters .Those filters should affect only their own state objects

I can achieve this with set analysis but I want to try with alternate states

Anonymous · ‎2017-03-14

Hi Tresesco,

Thanks for your response but It will not fit my requirement.If I use your logic,Location filter on product sheet is not affecting other objects on product sheet and I also don't want the location filter on customer sheet to affect the product sheet objects