topic Re: Adjustable timeline on graph in QlikView

Adjustable timeline on graph

Tue, 04 Feb 2014 15:53:54 GMT

Hi,

I have a graph, and I want to use a list box, to choose between a x-as in months or in weeks. I have a drop down menu on my graph at the moment, but I want my client to be able to change it with a list box. How do I do this? My dimensions are

Month(shipdate) as [Month]

Week(shipdate) as [Week]

Thanks in advance.

Re: Adjustable timeline on graph

luis_pimentel — Tue, 04 Feb 2014 16:02:37 GMT

Create a Data Island Table with two values for one field:

DimTable:

LOAD * INLINE [

DimField

Month

Week

];

Then set both dimensions on your chart and use the getFieldSelections function in the Conditional Showing option. That way, depending on what have you selected in that field, dimensions will be hiden/shown.

Hope that helps.

Re: Adjustable timeline on graph

MK_QSL — Tue, 04 Feb 2014 16:08:00 GMT

Create a Cyclic Group and use as a dimension.

Re: Adjustable timeline on graph

luis_pimentel — Tue, 04 Feb 2014 16:08:17 GMT

By the way, in the "What new" qvw for version 11 there is some great examples of this issue.

Re: Adjustable timeline on graph

Tue, 04 Feb 2014 16:17:29 GMT

Hi,

here is a sample document.

Hope it helps.

Best Regards