topic Variable as Dimension in QlikView

Variable as Dimension

Fri, 11 Jan 2013 03:06:12 GMT

Hi,

I need help to generate a chart with variable as x-axis dimension.

Please refer the file attached. It has a field Customer, and user can create groups of customer then in the chart instead of Customer in X axis I need Groups in X axis.

Thanks,

Sumita.

Re: Variable as Dimension

fosuzuki — Fri, 11 Jan 2013 11:10:12 GMT

Are you in v11? If so, I'd recommend using Alternate States. Attached modified qvw.

Re: Variable as Dimension

Fri, 11 Jan 2013 14:21:02 GMT

Thanks Fernando Suzuki for your reply.

But I'm still stuck with V9, so this isn't working for me.

Sumita

Re: Variable as Dimension

fosuzuki — Fri, 11 Jan 2013 14:33:10 GMT

So check this old sample. It uses a macro to store the groups in different bookmarks, and the uses the bookmarks in the set analysis.

I'm pretty sure I've downloaded it from this community, but don't know anymore to give the credits.

Re: Variable as Dimension

Tue, 15 Jan 2013 04:40:44 GMT

Thanks Fernando Suzuki, your second post was quite helpful. I shall update my solution soon, just for reference.

Sumita