topic Re: MultiBox and Grid Chart in QlikView

MultiBox and Grid Chart

Sun, 03 Aug 2014 09:37:52 GMT

Hi Friends,

I have a requirement, upon multi-boxes selection I need to change x axis, y axis.

Could you please help me in the logic how to proceed with above req?

Thanks

Arindam Roy

Re: MultiBox and Grid Chart

Yousef_Amarneh — Sun, 03 Aug 2014 11:57:35 GMT

your request is not clear, can you attach an example?

Re: MultiBox and Grid Chart

Mon, 04 Aug 2014 04:58:36 GMT

Hi Yousef,

Let's take an example.

I am having 2 multi boxes named

X axis: having data no. of customers, investment, ROI etc.

Y axis: Let say I am having list of months.

Let's focus on bar graph, during initial load my bar graph shows no. of customers on monthly basis. From my multi box, I can change X axis to investment, so my graph will show investment on monthly basis. Similarly I can change Y axis multi box.

Hope I am clear with my ask.

For more clarity, I request to have a look at Qlik Demos: See QlikView in Action | Demo.Qlik.Com

- Correlation Analysis. It is having multibox and scatter chart, upon select of any field of multibox, scatter chart get changed. I am looking for similar kind of functionality.

Thanks

Arindam Roy

Re: MultiBox and Grid Chart

kushalthakral — Mon, 04 Aug 2014 05:48:04 GMT

hi Roy

You can use Getselectedfield of the selected multibox.

Regards

Kushal Thakral

Re: MultiBox and Grid Chart

tresB — Mon, 04 Aug 2014 05:57:04 GMT

Dear Arindam,

Download the demo application from the site and you will see, it is not that complicated. You have to create an inline island with metric/dimension values. And then, use that inline field in the multibox/listbox selection; in the chart dimension you can make a group or even conditional dimensions.

Hope this helps.

Re: MultiBox and Grid Chart

Yousef_Amarneh — Mon, 04 Aug 2014 05:58:31 GMT

Hi Arindam,

You can create cyclic dimension group for the dimension set and measure group for the measures set instead of multi-boxes, so you can set Month, Year , Department ... etc. in one cyclic dimension group, and No. of customers, Investment ... etc in one measure group.