topic Re: Dynamic dimension in QlikView

Dynamic dimension

Thu, 12 Jul 2012 08:16:31 GMT

Hello,

I would like to construct a dynamic dimension based on selected value from a field.

For exemple :

I have a field "Product" with caracter value 'A', 'B', 'C', ...,'AA', 'ZZ'

I have also a selection list based on "Product".

If I select "Product" 'A' and 'C', I would like to have a dynamic dimension with two values : 'A' + 'C' versus the total values of "Product'.

I have got an idea to do this ? Help is appreciated, thank you!

Alain

Re: Dynamic dimension

magavi_framsteg — Thu, 12 Jul 2012 08:31:30 GMT

Hi Alain.Follet.

You can use the function GetFieldSelections.

Example:

if (GetFieldSelections(Product, '~') = 'A~C', [Use this dimension], [Else use that dimension])

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Dynamic dimension

Thu, 12 Jul 2012 11:22:48 GMT

I'm try to do this but I dont manage to success ...

The first dimension is OK but the second dimension contains only the complementary, not all the values.

Do you see what I mean ?

Kind regards,

Alain

Re: Dynamic dimension

Thu, 12 Jul 2012 11:27:15 GMT

Alain please send a qvw file

Re: Dynamic dimension

Thu, 12 Jul 2012 12:50:31 GMT

I can't manage to send qlikview file, only pictures or link ...

You can load this script :

Table:

LOAD * INLINE [

Store, Product, Sales

'A', 'P1', 5

'A', 'P2', 3

'A', 'P3', 3

'B', 'P1', 1

'B', 'P2', 2

'B', 'P3', 3

'C', 'P1', 2

'C', 'P2', 4

'C', 'P3', 2

];

After, add a select object for Store and construct this cross table (Store * Product) and sum the sales :

Store	Product	P1	P2	P3
A		5	3	3
B		1	2	3
C		2	4	2

I would like to have the same things but instead of Store 'A', 'B' and 'C', I would like to have another dimension

- Group 1 : selection of the select list of Stores (Several stores can be selected)

- Group 2 : the total of the Stores.

The exmple is very simple but in reality, the number of Stores is very important and it is impossible to write all the values.

Many thanks for your help.

Kind regards,

Re: Dynamic dimension

Fri, 13 Jul 2012 11:06:03 GMT

Hello,

Nobody can help me ?

Regards,

Alain

Re: Dynamic dimension

Fri, 13 Jul 2012 11:16:52 GMT

what do you mean - Group 2 : the total of the Stores.

sum?

jou want to have the selected Stores on top and the other(all or other?) below

am i right?

Re: Dynamic dimension

Fri, 13 Jul 2012 11:30:40 GMT

Are you looking for comparative analysis? Have you had a chance to look at the comparative analysis example in "What is new in QlikView 11" document --> Product Grouping tab? I think that is what you are looking for.

Re: Dynamic dimension

Fri, 13 Jul 2012 11:30:56 GMT

Re: Dynamic dimension

Fri, 13 Jul 2012 11:31:30 GMT

check this:)

Re: Dynamic dimension

Fri, 13 Jul 2012 11:34:20 GMT

Terrible !!

It is exacltly what I want to do.

Many Thanks.

Regards,

Alain

Re: Dynamic dimension

Fri, 13 Jul 2012 11:37:10 GMT

Re: Dynamic dimension

magavi_framsteg — Fri, 13 Jul 2012 21:31:05 GMT

So why is it terrible?

Re: Dynamic dimension

Mon, 16 Jul 2012 08:27:28 GMT

Terrible in the sense that I spent a lot of time to do it unsuccessfully...