Grouping Dimension Values

[#1]

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

[sunny_talwar · Accepted solution]

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

];

[#3]

THank you Sunny!

Why haven't I thought of this. will try right now

[#4]

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?

[sunny_talwar]

Have you made sure that Account Type is spelled the same was as it is in your database?

[sunny_talwar]

Spelled and even the casing should also be the exact same

Account Type is not the same thing as account type in QlikView

[#7]

I used qualify. so should I use the changed name or original name?

[#8]

just one more thing. account type / and group are both not in quotation mark?

[sunny_talwar]

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.

[#10]

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