Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
markgraham123
Contributor II

Group by dimension

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.

8 Replies

Re: Group by dimension

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

mark6505
Valued Contributor III

Re: Group by dimension

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

markgraham123
Contributor II

Re: Group by dimension

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.

harsh44_bhatia
Contributor

Re: Group by dimension

Hi,

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

Re: Group by dimension

Doesn't the Type field already do that?

mark6505
Valued Contributor III

Re: Group by dimension

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

markgraham123
Contributor II

Re: Group by dimension

Colin,

I should have been clear enough.

Let me repost the question and attachment.

Re: Group by dimension

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

]

;

Community Browser