- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Grouping Dimension Values
Hi,
I want to have account type as my dimension. account type has value A, B, C, D, E, F, G
What If I want to have A. B, C as Group 1. B, C, E as Group 2, E, F, G as Group 3?
it does overlap and I know that. but I want to have three dimensions Group 1, Group 2, Group3 and as described above they are combinations of original values.\
Thanks!
David
- « Previous Replies
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be create a linktable in the script:
LOAD * Inline [
Group, Account Type
Group 1, A
Group 1, B
Group 1, C
Group 2, B
Group 2, C
Group 2, E
Group 3, E
Group 4, F
Group 5, G
];
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be create a linktable in the script:
LOAD * Inline [
Group, Account Type
Group 1, A
Group 1, B
Group 1, C
Group 2, B
Group 2, C
Group 2, E
Group 3, E
Group 4, F
Group 5, G
];
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
THank you Sunny!
Why haven't I thought of this. will try right now
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny,
It is partly working bur partly not.
It is not being synchronized with existing values.
so the inline table to just on its own.
How can I link them up?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have you made sure that Account Type is spelled the same was as it is in your database?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Spelled and even the casing should also be the exact same
Account Type is not the same thing as account type in QlikView
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I used qualify. so should I use the changed name or original name?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
just one more thing. account type / and group are both not in quotation mark?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What name do you see for your field in the data model viewer or when yoy create a list box for it? Use the same exact name in the inline load.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes I did just that. Now there is one thing that i am suspecting that is the reason for this.
I am currently pulling the data directly from database without going through QVD.
is that why this is not working?
I have found a little difference between using QVD and direction connection.
when I used QVD it was so easy to just do something like adding a line that says
1 as count
and it there will be another column but it does not work when I am connecting directly to database.
Can this be the reason?
Thanks!
David
- « Previous Replies
- Next Replies »