topic Re: Re: Break bar chart into 2 in QlikView

Break bar chart into 2

techvarun — Fri, 18 Jul 2014 09:48:04 GMT

Hi All,

I have a barchart with 20 values(maximum) I need to split the chart into 2 whenever it exceeds the count 10. so my requirement is to show the same chart as two segments...

will it possible? or else i need to design a new chart?

Please advice me

Regards

Re: Break bar chart into 2

MK_QSL — Fri, 18 Jul 2014 09:49:29 GMT

how you want to make two segments? You want to show two different bar charts?

Re: Break bar chart into 2

Anonymous — Fri, 18 Jul 2014 09:52:49 GMT

How about using the GetSelectedCount() function to then check if you have > 10 values selected and then use that to conditionally display the 2nd chart ?

Re: Re: Break bar chart into 2

techvarun — Fri, 18 Jul 2014 09:56:20 GMT

Thanks for the super fast reply Manish,

No in a same chart till 10 it should be in a row, if it exceeds 10 it should start display from top.

Re: Re: Break bar chart into 2

MK_QSL — Fri, 18 Jul 2014 09:57:17 GMT

Don't think so it is possible but you can make two chart and put one on another

Re: Re: Break bar chart into 2

techvarun — Fri, 18 Jul 2014 10:01:47 GMT

Thanks Bill,

The list box have about 4000 values and I am showing only the top 20 values on chart.

GetSelectedCount() function will work in this case?

Re: Break bar chart into 2

MK_QSL — Fri, 18 Jul 2014 10:04:25 GMT

Use Rank Function for showing first 10 values on chart...

Use Again Rank Function for showing next 10 values on another chart

Keep both chart near as per your attachment...

Hope this helps...

Re: Break bar chart into 2

Fri, 18 Jul 2014 12:37:53 GMT

Hi,

If you are using QV11 you can try trellis to break your dimension individually into 20, and they arrange them in 2 by 10 configuration to get the desired effect.

Hope it works for you.

Regards

Rahul