Two dynamic dimensions showing only when selection made

Mon, 05 Sep 2011 14:03:05 GMT

Hi Everyone,

I have a table I wish to make dynamic. It is basically an Annual or Monthly trending table. The annual one only has one dimension (Year) and the monthly one has two (Year, Month).

I want to have a dropdown or selection box where the user selects 'Annual' or 'Monthly' and the table changes automatically.

I have tried my usual solution by creating a table like this (notice the blank on the first line for M_DIM):

ANNUAL_MONTHLY_SELECT:

LOAD * INLINE [

AM_SELECT, A_DIM, M_DIM

Annual Trends, T_SALE_YEAR_LST5,

Monthly Trends, T_SALE_YEAR_LST12, T_SALE_MTH_LST12

];

I then setup the following two calculated dimensions in the straight table:

$(=A_DIM)

$(=M_DIM)

This works well for the Monthly Trends as there are two dimensions. When I try and select Annual Trends, however, QV crashes *every time*. I'm assuming this is caused by having a blank for M_DIM for the Annual Trends.

Has anyone set up something similar perhaps a different way or can help me with my way?

Thanks

Gareth

Two dynamic dimensions showing only when selection made

Mon, 05 Sep 2011 14:27:09 GMT

Hi Gareth,

You can solve this by creating two tables: one for the monthy trends and one for the annual trends; then add a showing condition in each one.

Regards!

Re: Two dynamic dimensions showing only when selection made

Tue, 06 Sep 2011 01:31:42 GMT

Hi,

Please see if the attached can help you.

Cheers.

Re: Two dynamic dimensions showing only when selection made

Tue, 06 Sep 2011 08:10:47 GMT

Thanks both, very helpful!

topic Re: Two dynamic dimensions showing only when selection made in QlikView

Two dynamic dimensions showing only when selection made

Two dynamic dimensions showing only when selection made

Re: Two dynamic dimensions showing only when selection made

Re: Two dynamic dimensions showing only when selection made