i have 6 rows, i want to divide them into 2 groups (direct, indirect), how can I achieve this?

[#1]

i have 6 rows, i want to divide them into 2 groups (direct, indirect), how can I achieve this?

[sinanozdemir]

Hi Raghu,

Can you post an example data set?

[jagan]

Hi,

Post some sample data so that it would be easier to provide the solution.  How the rows are identified into two different groups?  If you have a group column then add it to the chart.

Regards,

Jagan.

[avinashelite]

Hi Raghu,

Please post the sample app with data and the output format you require, so that it will be helpful for us to understand .

[#5]

   A                        B

OEM	Indirect
1 Tier	Indirect
Direct	Direct
MSP	Indirect
2 Tier	Indirect
FM	Direct
Usage	Indirect

I want to all the rows in column A to be grouped in 2 groups( Direct, Indirect).

[sinanozdemir]

I think you can achieve this in two ways:

In the load script, with Wildmatch:

Or in the front end with Wildmatch:

Hope this is what you are looking for.

[#7]

I used the second method, but the output is direct for both the cases

[jagan]

Hi Raghu,

It is a good practice to load it as a separate table and like below

ActualData:

LOAD

A,

,

,

FROM DataSource;

MappingTable:

LOAD

*

INLINE [

A ,                       B

OEM,	Indirect
1 Tier,	Indirect
Direct,	Direct
MSP,	Indirect
2 Tier,	Indirect
FM,	Direct
Usage,	Indirect

];

If you want you can also use mapping load instead of Mapping table, check Qlikview help file for Mapping Load concept.

Hope this helps you.

Regards,

Jagan.

[Anonymous]

A variation of the same which adds B into the original data:

ActualData:

LOAD

A,

,

,

FROM DataSource;

LEFT JOIN (ActualData)

LOAD

*

INLINE [

A ,                       B

OEM,	Indirect
1 Tier,	Indirect
Direct,	Direct
MSP,	Indirect
2 Tier,	Indirect
FM,	Direct
Usage,	Indirect

];

[#10]

Thanks Michael.