topic How to change the x-axis dimension dynamically? in QlikView

How to change the x-axis dimension dynamically?

Thu, 29 Aug 2013 05:20:49 GMT

Hi Friends,

Help me to resolve this problem. I have 4-different types of chart in a single page. Each charts has its own x-axis dimension value.

I have a List Box object in the same page which has 5-chart-Type. However when i select the chart-type from list box it will show all 4-charts related to the chart-type gets loaded on page based on the calculation. At this point i also need to change the x-axis dimension dynamically as-well. Kindly share your ideas.

The problem was, I have assigned the x-axis dimension statically.

Thank you,

Re: How to change the x-axis dimension dynamically?

jagan — Thu, 29 Aug 2013 05:24:03 GMT

Hi,

In Dimension tab use Add Calculated dimension to conditionally get the dimension like this

If(Condition1, Dim1, If(Condition2, Dim2, Dim3))

Hope this helps you.

Regards,

Jagan.

Re: How to change the x-axis dimension dynamically?

Thu, 29 Aug 2013 05:38:35 GMT

suppose fieldname of listbox is type.

now then in chart1--> dimension--> calculated dimension---> if(type = charttype1, Dimensionfield)

similarly

in chart2--> dimension--> calculated dimension---> if(type = charttype2, Dimensionfield)

similarly

in chart3--> dimension--> calculated dimension---> if(type = charttype3, Dimensionfield)

similarly

in chart4--> dimension--> calculated dimension---> if(type = charttype4, Dimensionfield)

Re: How to change the x-axis dimension dynamically?

Thu, 29 Aug 2013 06:00:17 GMT

Hi Kumar,

Thanks for your useful reply. I will apply all the possible that you have suggested for me and let you know.

Regards,

--Thiru

Re: How to change the x-axis dimension dynamically?

jagan — Thu, 29 Aug 2013 06:04:42 GMT

HI,

If you are using Qlikview 11 then this work

in chart2--> dimension--> calculated dimension---> if(type = charttype2, Dimensionfield)

Re: How to change the x-axis dimension dynamically?

Thu, 29 Aug 2013 06:05:01 GMT

Hi Jagan,

Thanks for you reply. I will try with your idea and let you know.

Regards,

--Thiru