topic Re: Alternate States in QlikView

Alternate States

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I was wondering if any one has had any performance issues using Alternate States. I have a rather large data set and was thinking about using multiple alternate states for various visualizations. I currently have built out 7 and haven't seen any slowness, but am going to end on 10 or 11 and wanted to see if others have run into any issues.

Re: Alternate States

Clever_Anjos — Thu, 04 Aug 2016 17:36:43 GMT

Yes, you have performance implications using Alternate States.

Usually we use 2 states to make comparison between 2 sets.

Why do you need 7 ? Can´t you reuse them between comparisions?

Re: Alternate States

Thu, 04 Aug 2016 17:39:57 GMT

On a single tab, I have 7 small visualizations that all use the same fields and I do not want them interacting with each other.

Re: Alternate States

Clever_Anjos — Thu, 04 Aug 2016 17:55:38 GMT

Can´t you use Set Analysis disregarding selections?

Re: Alternate States

Thu, 04 Aug 2016 18:05:42 GMT

Perhaps? I didn't know how to do that.

How would I accomplish that? For simplicity, let's just say I have 2 states for 2 different charts.

State 1

Chart 1: Pivot Table

Dimension: Person

Dimension: Service Date

Expression: Count Service Date with set analysis limiting what to count to a specific scenario

State 2

Chart 2: Pivot Table

Dimension: Person

Dimension: Service Date

Expression: Count Service Date with set analysis limiting what to count to a different specific scenario

If I click on a Person in Chart 1, I do not want Chart 2 to drill down to shown only that Person. I want it to remain untouched.

Re: Alternate States

Clever_Anjos — Thu, 04 Aug 2016 19:21:46 GMT

I don´t see another solution besides Alternate into your scenario. Prepare to add RAM to your QVBox

Re: Alternate States

Thu, 04 Aug 2016 19:28:23 GMT

Darn, I was hoping there was a better solution!

Re: Alternate States

sudeepkm — Thu, 04 Aug 2016 19:37:21 GMT

Alternate to "alternate states" could be

1. Loading that dimension field Person as a different field like PersonX (x as 1, 2, 3, .. n) in another table not linked to the main table.

2. Then building multiple versions of the same chart and multiple list boxes having Person1, Person2 .. etc respectively

3. Use expression with set analysis to use the current selection of the list boxes respective to each version of "Person" field.

This is how I did when we didn't have Alternate states. I'm not sure how it would be based on performance. you can check though.

Re: Alternate States

Clever_Anjos — Thu, 04 Aug 2016 20:20:54 GMT

RAM is not that expensive nowadays