topic Group by dimension in QlikView

Group by dimension

markgraham123 — Tue, 09 Feb 2016 15:53:04 GMT

Hi all,

I was struck at a basic 'if expression' which should separate the Categories based on ID and Name.

ID,	Name,	Type
abcd,	123,	A
abcd,	456,	B
efgh,	789,	A
ijkl,	1011,	B
mnop,	1213,	A
qrst,	1415,	B

Here i want to create two new fields ID Category and Name Category which will differentiate it's own types - A and B.

any help is highly appreciated.

Please find the attachment.

Re: Group by dimension

Colin-Albert — Tue, 09 Feb 2016 15:58:50 GMT

Can you give an example of what the expected output for ID Category and Name Category should be?

Re: Group by dimension

Mark_Little — Tue, 09 Feb 2016 15:59:34 GMT

Hi,

Can you supply some more information?

How are you defining the two new fields?

Even if you just stated in English would be helpful.

Mark

Re: Group by dimension

markgraham123 — Tue, 09 Feb 2016 16:01:43 GMT

Hi Colin,

The ID Category and Name Category should have the flags A, B.

Such that, We can differentiate the categories by ID and Name level.

Re: Group by dimension

harsh44_bhatia — Tue, 09 Feb 2016 16:02:55 GMT

Hi,

Can you state with eg, how you want to create the two ID columns

Re: Group by dimension

Colin-Albert — Tue, 09 Feb 2016 16:05:33 GMT

Doesn't the Type field already do that?

Re: Group by dimension

Mark_Little — Tue, 09 Feb 2016 16:06:58 GMT

Hi,

Yer I am think the same as Colin, sure just selections on the Category or even just the type column does that already?

Mark

Re: Group by dimension

markgraham123 — Tue, 09 Feb 2016 16:09:03 GMT

Colin,

I should have been clear enough.

Let me repost the question and attachment.

Re: Group by dimension

Colin-Albert — Tue, 09 Feb 2016 16:10:25 GMT

Just rename the Type field to Category in the load

Table1:

LOAD

ID,

Name,

Type as Category

Inline

[

ID, Name, Type

abcd, 123, A

abcd, 456, B

efgh, 789, A

ijkl, 1011, B

mnop, 1213, A

qrst, 1415, B

]

;