Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
sunny_talwar

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

];

View solution in original post

21 Replies
sunny_talwar

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

];

Not applicable
Author

THank you Sunny!

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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