topic Re: Selections in chart dimensions in QlikView

Selections in chart dimensions

PradeepReddy — Fri, 31 Jan 2014 14:06:56 GMT

Hi all,

I am trying for this requirement for a long time. Here is the requirement.

I have 3 List boxes, one Bar chart, onr pivot table and 2 gauge charts.

Suppose I have a List box with the same dimension in Barchart as well. If I click on any of these (List box/Barchart), then the other chart(Pivot Table) is appearing. But my requirement is.. whenever I click on the Barchart, then only the other chart(Pivot table) should be appeared.

I tried with the alternate states also. But it is segregasting the objects with the rest in the document.

I am attaching the QVW for the same.

Thanks,

Pradeep

Re: Selections in chart dimensions

Fri, 31 Jan 2014 14:16:15 GMT

Hi Pradeep

What's the difference between your current solution and your goal? What's exactly wrong with attached document?

Lukasz

Re: Selections in chart dimensions

Gysbert_Wassenaar — Fri, 31 Jan 2014 14:20:16 GMT

I don't think this can be done. A selection in the bar chart is exactly the same event as a selection in the listbox. There is no way to distinguish between them. It's like having two light switches for the same light. You can't tell from the light which switch was used.

Re: Selections in chart dimensions

Anonymous — Fri, 31 Jan 2014 14:44:06 GMT

Pradeep,

You can try something using macros and variables. See attached example, it has a macro that checks if the bar chart is active, and sets variable. The variable is included in chart show condition. So, the behavior is different depending where you make the selection.

(Not a comprehensive solution, just an idea to try.)

Regards,

Michael

Re: Selections in chart dimensions

jerem1234 — Fri, 31 Jan 2014 20:21:17 GMT

Here might be a way to do it using alternate states like you mentioned. I added an alternate state TriggerState and set the chart to this state. Then I used this expression to listen to default state:

sum({<Dim1=$::Dim1,Dim2=$::Dim2,Dim3=$::Dim3>}Expression1)

Then I created a variable, vSwitch, with this expression:

=concat({TriggerState}distinct Dim1)

Then I added an action for the variable using document properites -> Triggers -> OnChange

Add Action: Copy State Contents, Source: TriggerState, Target: $

From there, we need to change condition to show charts.

Bar Chart:

count({TriggerState}distinct Dim1) = count({1}distinct Dim1)

Straight Table:

count({TriggerState}distinct Dim1) <> count({1}distinct Dim1)

There are some drawbacks to this, such as there not being any function like GetSelectedCount for alternate state (which is why the conditional is the way it is), the expression for your chart needs extra set analysis to listen to default state: {<Dim1=$::Dim1,Dim2=$::Dim2,Dim3=$::Dim3>}, and you have to clear selections in order to see bar chart again (or at least clear TriggerState). This may help you get a workaround going as well.

Please find attached.

Hope this helps!

Re: Selections in chart dimensions

PradeepReddy — Mon, 03 Feb 2014 05:07:55 GMT

Whenever we click on the Barchart then only the Pivot table should be appear. They should not be in any seperate group.

Re: Selections in chart dimensions

PradeepReddy — Mon, 03 Feb 2014 05:11:18 GMT

Thanks Gysbert

But the requirement is like that only.. 😞 . Need to check with the business once again.

Re: Selections in chart dimensions

PradeepReddy — Tue, 04 Feb 2014 14:10:52 GMT

Thanks Michael..

I have opted your logic and made the necessary changes..It's working..