topic Re: Alternate States in QlikView

Alternate States

dathathreya — Wed, 25 Nov 2020 16:16:04 GMT

Hai all,

I am facing a problem plz help me out.Thanks in Advance.

Here is the scenario like i have a list box and two charts like A and B charts for these two charts i am defining each state and if i filter the list box the two charts has to work.

Re: Alternate States

florentina_doga — Thu, 22 Jun 2017 12:51:30 GMT

pls see attach !

Re: Alternate States

dathathreya — Thu, 22 Jun 2017 12:54:18 GMT

hi florentina i am using desktop version so can u plz share the image and explore it in detail .

Re: Alternate States

florentina_doga — Thu, 22 Jun 2017 13:04:59 GMT

Re: Alternate States

dathathreya — Thu, 22 Jun 2017 13:07:18 GMT

Re: Alternate States

dathathreya — Thu, 22 Jun 2017 13:09:00 GMT

in the above image like if i select the list box year it has to associate with the other two charts .

In my dashboard there are other list boxes and other charts also.so only i am using the alternate states here.

Re: Alternate States

oscar_ortiz — Thu, 22 Jun 2017 13:16:14 GMT

If the chart on the left is using alternate state "A" and the chart on the right is using alternate state "B" what state is the list box in? Generally I want to have two list boxes, one with alternate state "A" and the other with alternate state "B", similar to the image that florentina.dogaru‌ mentioned.

Re: Alternate States

dathathreya — Thu, 22 Jun 2017 13:22:27 GMT

Hi Oscar Ortiz,

If we add an another list box and define it as the state B it will work but in my dashboard and my scenario is not like that .from one list box it self i have show the changes in the chart.if it is not possible with alternate states can u plz tell me any other alternate way to overcome this.

Re: Alternate States

oscar_ortiz — Thu, 22 Jun 2017 13:29:33 GMT

Datha,

What I'm not understanding is what the difference would then be between the two charts? If I am using the same dimension how is the alternate state working for you. What are you hoping to accomplish.

You can set up two charts without the alternate state associated to the objects and then modify the expressions themselves to use alternate states in set analysis. But without truly understanding what you are trying to accomplish it is difficult to give you guidance.

Oscar

Re: Alternate States

henrikalmen — Thu, 22 Jun 2017 13:36:20 GMT

In your chart expression, add set expression like this:

{<MonthYear = $::MonthYear>}

This instructs the chart in the active state to use MonthYear selection from default ($) state.

So the expression in both charts would then be: sum({<MonthYear=$::MonthYear>}Valoare)

Re: Alternate States

dathathreya — Thu, 22 Jun 2017 13:41:32 GMT

Thankq Very much

Re: Alternate States

kvanandan1 — Thu, 22 Jun 2017 13:49:52 GMT

Hi,

I have created 3 fields Item,Sales,Qty.

Created a item as a listbox and 2 charts one for sales and other for qty. In the chart1 expression i have created sum({A<Item = $::Item>} Sales) and chart2 expression sum({B<Item = $::Item>} Qty).

Now selecting item from drop down list , both charts will change for the selected item.

Is this is requirement.

Re: Alternate States

kvanandan1 — Thu, 22 Jun 2017 13:52:05 GMT

One more thing , create alternate state A and B, and assign to alternate state A to chart1 and B to chart2.

Hope this helps.