Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
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
];
THank you Sunny!
Why haven't I thought of this. will try right now
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?
Have you made sure that Account Type is spelled the same was as it is in your database?
Spelled and even the casing should also be the exact same
Account Type is not the same thing as account type in QlikView
I used qualify. so should I use the changed name or original name?
just one more thing. account type / and group are both not in quotation mark?
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.
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