topic Re: Charts sort order based on selection in QlikView

Charts sort order based on selection

Navars — Wed, 24 Jul 2019 04:59:49 GMT

Hi All,

I have a list box called Group name, it has 10 groups and in the report I have 10 charts.

when ever user make first selection(user will choose the group randomly) first chart should enable, for second selection second chart should enable etc..

I am able to do that, but problem here is Charts are changing based on selections, means if the user selected Group1 chart1 should enable and if the user selects Group2 it suppose to enable the chart2 but in my case its group2 selection is going to chart1 and group1 selection is coming to chart2 automatically.

Thanks,

Sra1..

Re: Charts sort order based on selection

shiveshsingh — Wed, 24 Jul 2019 05:10:23 GMT

May be you have wrongly applied trigger condition.

What is the conditional statement? Please share

Re: Charts sort order based on selection

jonathandienst — Wed, 24 Jul 2019 05:26:31 GMT

That's how Qlik is designed to work. Selections are applied to all objects on all sheets (unless explicitly overridden in a set expression). It is possible to do what you want but certainly not simple.

Re: Charts sort order based on selection

shiveshsingh — Wed, 24 Jul 2019 05:28:15 GMT

Yes, correct.

Couldn't get the exact problem previously!

Re: Charts sort order based on selection

Navars — Wed, 24 Jul 2019 05:35:55 GMT

I am using the below condition to enable the chart

=if(isnull(subfield(GetFieldSelections(Group_Name, '|',1000), '|', 1)) and isnull(subfield(GetFieldSelections(lte.kpi_name_charts, '|',1000), '|', 1)),0,1)

Re: Charts sort order based on selection

shiveshsingh — Wed, 24 Jul 2019 05:38:53 GMT

Let me know if I got your issue wrong, When you select the group value for chart 1 , selections are also impacting CHart2?

Re: Charts sort order based on selection

Navars — Wed, 24 Jul 2019 05:55:24 GMT

No data impacting, only charts are interchanging.

for eg. user selected group1 that time chart1 needs to enable and that is happing fine,

when user selects group3 (this is second selection in group list box, user will chose the group randomly) in this case chart2 will enable, it is also working fine.

what is happening here is when user make second/third selections the charts are interchanging means first chart data coming to second chart, second chart data displaying in first chart.

my requirement here is that charts are fixed for the selections, means if user make first selection first chart should enable, for second selection second chart should enable, for third selectin third chart should enable etc..

Re: Charts sort order based on selection

Brett_Bleess — Wed, 14 Aug 2019 21:56:57 GMT

Sravan, check the chart Object ID on the charts, is it the same ID across all of them, I am attaching a screenshot, so you know exactly what I mean here. If the ID is the same for all of them, I think that is likely why things are behaving as they are. The problem is I cannot remember how to do this in the first place in order to tell you how to undo it! 🙂

Regards,
Brett

Re: Charts sort order based on selection

Brett_Bleess — Mon, 19 Aug 2019 13:05:58 GMT

The only other things that came to mind here are Alternate States and potentially the Detached options:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Alternate%20States.htm

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Detach_Chart.htm

If you got things sorted, please consider leaving update with what the issue was and what you did, so everyone will know what you did here, you can mark that post as the solution as well...

Regards,
Brett