topic Re: open a chart by selecting something in another chart? in QlikView

open a chart by selecting something in another chart?

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a summary chart which gives me the difference between two sources. On selecting the difference (source1- source2) field, a new chart(Issue Summary) with detailed information should open? How can achieve it?

object ID CH29object ID CH19

Thanks in advance.

Re: open a chart by selecting something in another chart?

vishsaggi — Fri, 12 Aug 2016 20:30:06 GMT

Try this?

1. in the script or using Ctrl+Alt+V set a variable

SET vShow = 1;

2. In your issue summary table chart -> Chart properties -> Layout Tab -> click radio button Conditional and type this

= vShow = IF(GetFieldSelections(RecordType) > 0 , 1, 0)

When you select anywhere in your Summary table based on selection it should hide and show the Issue Summary table. If you clear all it iwll hide the table. I have not tried , let me know if you face any issues.

Re: open a chart by selecting something in another chart?

Mon, 15 Aug 2016 14:02:36 GMT

I tired it.. The chart is hidden with the condition but its not popping with when I click the difference or the record type...Thanks Vish

Re: open a chart by selecting something in another chart?

vishsaggi — Mon, 15 Aug 2016 15:42:25 GMT

Can you mask the data and send me your qvw file you are working on if possible ?