Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic dimension

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

13 Replies
magavi_framsteg
Partner - Creator III
Partner - Creator III

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.

Not applicable
Author

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

Not applicable
Author

Alain please send a qvw file

Not applicable
Author

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 :

StoreProductP1P2P3
A 533
B 123
C 242

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,

Not applicable
Author

Hello,

Nobody can help me ?

Regards,

Alain

Not applicable
Author

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

sum?

or

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

am i right?

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

check this:)