topic Re: Help with Alternate States in QlikView

Help with Alternate States

vindhya_giri — Thu, 05 Nov 2015 16:59:53 GMT

I have an application in which I am using alternate states. I have a tab with straight table and 2 filters tab, 1 for State A and the other for State B selection. The issue is that, when I am trying to make selections in the straight table, they are not reflecting on the filters tab list boxes. Also, the Current selection box shows that the field is selected in the straight table but it is not getting reflected in the straight table too. Basically, when I am making selections in the straight table it is not working. But when I am making the same selections in both the filters tab, they are reflecting on the straight table.

Any suggestions please

Thanks

Re: Help with Alternate States

swuehl — Thu, 05 Nov 2015 17:05:10 GMT

This happens when your chart is set to default state and you are using set analysis in the chart expression to get your alternate states into the game.

What would you expect to happen instead?

Maybe it's best to set the chart to read-only on general tab to not mess up with default state.

Re: Help with Alternate States

Thu, 05 Nov 2015 17:08:23 GMT

the issue is state a and state b currently apply to the 2 filters. The straight table is not assigned to any state (A or B) and neither is the current selection box. Both the current selection box and straight table are using the default state so that is why the current selection only reflects selections within the striaght table

Usually with alternate states, you have 2 sits of filters, which you have, but also 2 sets of charts so you can filter each set of charts based on different criteria

Re: Help with Alternate States

beck_bakytbek — Thu, 05 Nov 2015 17:12:37 GMT

Hi Vindhya,

try to use the Set-Expression instead of Alternate State.

kindly

Beck

Re: Help with Alternate States

Thu, 05 Nov 2015 17:14:45 GMT

Another question would be - what is the business case/what are you trying to accomplish?

If you could explain, we could determine the best way for you to address - as you can see from other responses, maybe alternate states is not the correct approach

Re: Help with Alternate States

vindhya_giri — Thu, 05 Nov 2015 17:26:26 GMT

Hi Adam,

The business case is that we have a straight table from which the users export to excel for their analysis. This way they are doing it by selecting the year/month they want from the list box. Now, what they want is, they want to compare two year/month(example 2015/08 and 2014/08). Currently, they are selecting 2015/08 export to excel and then select 2014/08 and export to excel. then they are comparing those two excels for their analysis. So, to overcome this, created alternate states. list box with State A in which they select 2015/08 and list box with state B in which they select 2014/08 so they can do side by analysis for comparison in one straight table instead of exporting it twice.

Please Advise

Thanks

Re: Help with Alternate States

vindhya_giri — Thu, 05 Nov 2015 17:33:28 GMT

Hi swuehl.

Your idea of read only helps so that the user has no chance to make selections in the straight table but instead make selections in the filters tabs only. But, I also want to know if there is a way to overcome when user make selections in the straight table, it should reflect on both the filters tab?

Please advise

Thanks

Re: Help with Alternate States

Thu, 05 Nov 2015 17:38:45 GMT

if you want to do side by side comparisson, which is ideal for alternate states, you really need to objects, in this case 2 straight tables, one with state a and other other with state b - make your selections with each filter and then you will have the results in one table based on dates in filter state a and the other based on filter state B

Re: Help with Alternate States

vindhya_giri — Thu, 05 Nov 2015 17:48:01 GMT

when I am trying to do with two tables, the tables are coming up properly with inherited state but when I make selections in the tables, they are not getting selected even though it shows as selected(green dot beside the field heading). When I am trying to change the states , one with state A and the other straight table with state B, the table itself is getting hidden

Please advise

Thanks

Re: Help with Alternate States

swuehl — Thu, 05 Nov 2015 17:59:30 GMT

If you make selections in charts, you effectively select dimension values. Since the chart is in default state, your dimension values will be selected in default state.

If you want a selection in default state to be copied to the alternate states, you can use triggers (like field event triggers) with appropriate actions, but it could makes things quite nasty.

You can also have your set expression in the chart consider the default state dimension set, so you don't even need to copy selections around.

=Sum({AS1<Date = $::Date>*AS2<Date=$::Date>} Value)

Re: Help with Alternate States

vindhya_giri — Fri, 06 Nov 2015 14:43:56 GMT

Swuehl,

I agree with your idea of not considering the triggers option. I believe making the chart to a read only state is a better idea in my case. I wanted to know, how can I make a pop up message appear while the user tries to select something from the straight table, asking to make selections from the filters tab?

(I have created a text box with message but not sure how to give action : when the user clicks on the straight table object, this text box should appear)

Please advise

Thanks

Re: Help with Alternate States

swuehl — Fri, 06 Nov 2015 15:08:23 GMT

You can create a text box, with option top layer in layout tab and transparency set to maximum.

Make this text box large enough to cover your chart, and enable an action to trigger a variable change.

Based on the variable, show your text box with the message.

Re: Help with Alternate States

vindhya_giri — Fri, 06 Nov 2015 15:36:00 GMT

I created text box with top layer and max transparency and made the text box large as chart.

Can you please guide me further.

Ex my straight table objID is CH 10 and text box obj id is TX 4

Thanks

Re: Help with Alternate States

swuehl — Fri, 06 Nov 2015 16:24:08 GMT

Have a look at attached sample QVW.

Re: Help with Alternate States

vindhya_giri — Fri, 06 Nov 2015 17:58:18 GMT

Swuehl,

Sorry, I am still not clear on it.

I see 3 text boxes . So, am I suppose to create 3?

If I am suppose to create just 1 text object, then I have to define the variable in the same text object? Then how am I suppose to relate to the click on the straight table with this text object? Also, I want the text object to disappear when the selections are made on filters tab.

Sorry, but plz bare with my questions.

Re: Help with Alternate States

swuehl — Fri, 06 Nov 2015 18:22:05 GMT

TX02 is just to display a small close window icon 'X' with an action to reset the variable to zero.

Click on the chart, then the other two text boxes should show up. then examine all properties and actions.

Re: Help with Alternate States

Anonymous — Fri, 06 Nov 2015 18:25:56 GMT

Do you use $ or 1 in any Set Analysis on any of your expressions as that will override any inherited state ?

Re: Help with Alternate States

vindhya_giri — Fri, 06 Nov 2015 19:09:28 GMT

Hi Bill,

I am using $ in set analysis

Thanks

Re: Help with Alternate States

Anonymous — Fri, 06 Nov 2015 20:04:35 GMT

The $ will explicitly use the Default State, so delete the $ and then it will use the Inherited State.

Re: Help with Alternate States

vindhya_giri — Mon, 09 Nov 2015 14:50:19 GMT

Thanks Swuehl. I was able to do it using your sample qvw as reference.

I also request to let me know if later you come across any workaround for: user make selections in the straight table, it should reflect on both the filters tab (for the case explained in original post).

Thank you