Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Alain.Follet.
You can use the function GetFieldSelections.
Example:
if (GetFieldSelections(Product, '~') = 'A~C', [Use this dimension], [Else use that dimension])
Kind regards
BI Consultant
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
Alain please send a qvw file
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,
Hello,
Nobody can help me ?
Regards,
Alain
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?
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.
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.
check this:)