topic Re: Alternate state wont work on sheet level in QlikView

Alternate state wont work on sheet level

Fri, 12 Jul 2013 12:22:11 GMT

I have multiple sheets, and i dont want one of my sheets to be affected by other sheets selections.

But if i give me sheet an alternatestate called "LeaveMeAlone"

Then selections from other sheets is still possible.

What am i doing wrong?

Re: Alternate state wont work on sheet level

Gysbert_Wassenaar — Fri, 12 Jul 2013 12:34:10 GMT

Check that the objects on the sheet with the LeaveMeAlone alternate state have their alternate state set to <inherited>.

See attached qvw for an example.

Re: Alternate state wont work on sheet level

Fri, 12 Jul 2013 13:00:48 GMT

All my objects are inherited on the sheet.

The funny thing is that. My current selections are showing there are no filters on. But it filters my listboxes and chart.

Re: Alternate state wont work on sheet level

swuehl — Fri, 12 Jul 2013 13:29:28 GMT

Are you using set analysis in your charts, potentially referencing the default state?

This won't explain your list boxes showing your selections on a different sheet, though.

Are your objects updated when you do a selection on a different sheet?

And when you create a new list box on your "LeaveMeAlone" sheet and select a value?

Any chance that you can upload a small sample qvw that demonstrates your issue?

Re: Alternate state wont work on sheet level

Fri, 12 Jul 2013 14:04:43 GMT

ived attqached the file. sorry for it being so big. Couldnt figure out how to reduce it all..

Try to select something resource planning, then it will also be on pipeline (but not in current selections)

Pipeline has alternate state

I use set analysis yes, but should i refer to pipeline? and if yes, how?

I use alternate state on the last listbox, on one expression because only this expression should be affected by that listbox

Re: Alternate state wont work on sheet level

Gysbert_Wassenaar — Fri, 12 Jul 2013 14:09:51 GMT

=sum({$<"[DimCusto...

Yes, you're referencing the default state with the $. So all the fields where you don't use modifiers to overrule selections will use the selections of the default state. If you leave out the $, i.e. sum({<"[DimCusto..., you would use the inherited state.

Don't feel bad about it. It's a real gotcha. See this blog post:Set Analysis & Alternate States – Quick Tip

Re: Alternate state wont work on sheet level

swuehl — Fri, 12 Jul 2013 14:13:10 GMT

Yep, I think my assuption was correct.

You are using set analysis in your charts (and also in your field expressions in list boxes), for example:

only({$<Year={$(=Year(Today()))},"[DimCustomer].CustomerName"=[Customer]::"[DimCustomer].CustomerName" ....

Here you copy selection of CustomerName from alternate state Customer to your inherited state Pipeline. I haven't checked everything related, but I believe that's causing your problem.

Re: Alternate state wont work on sheet level

Fri, 12 Jul 2013 14:14:57 GMT

Oops, just look besides Customer:: it was some old stuff, i forgot to remove it.

But thanks, didnt know that $ was implicit default state. So i have to leave out $ in order to alternate state to work?

Re: Alternate state wont work on sheet level

Fri, 12 Jul 2013 14:17:24 GMT

Omg...Thats horrible! But still awesome...

Thanks alot