topic Re: Grouping to data in QlikView

Grouping of data

Fri, 07 Aug 2015 09:15:12 GMT

Hi All, Suppose I have one field Company which has values like TCS,HCL, Infosys, Mphasis etc. when I select TCS in list box than i will see other IT competiators in other List box including TCS. How we can achieve this ?? Can anyone give me idea Thanks in advance Regards Deepak

Re: Grouping to data

sorrakis01 — Fri, 07 Aug 2015 09:17:26 GMT

Hi,

Can you upload your model?

Regards

Re: Grouping to data

sunny_talwar — Fri, 07 Aug 2015 09:20:43 GMT

May be like this:

MainTable:

LOAD Company,

Industry

FROM Source;

Join (MainTable)

LOAD Company as Competitors,

Industry

Resident MainTable;

Re: Grouping to data

sunny_talwar — Fri, 07 Aug 2015 09:34:39 GMT

Example Attached:

Script:

Table:

LOAD * Inline [

Company, Industry, Sales

ABC, IT, 50

DEF, IT, 60

GHI, Finance, 80

ABK, Finance, 100

LBB, Healthcare, 20

TKP, Healthcare, 40

JLK, Healthcare, 30

];

Join(Table)

LOAD Industry,

Company as Competitor

Resident Table;

When I select Company ABC, I see ABC and DEF as Competitors

Re: Grouping of data

Fri, 07 Aug 2015 09:44:38 GMT

Thanks Sunny 🙂

Re: Grouping of data

Mon, 10 Aug 2015 09:59:52 GMT

Hi Sunny Thanks for your effort but your output is not correct 100 % if we select company ABC than it should return the value of the competitors ABC and DEF which is 50 and 60 but in above post which is not correct . Can you give me some idea to achieve it ?? Deepak

Re: Grouping of data

sunny_talwar — Mon, 10 Aug 2015 10:25:42 GMT

This:

Re: Grouping of data

Mon, 10 Aug 2015 11:17:16 GMT

Thanks a lot sunny. I am facing issue in my data set actually i have multiples fields but i m using only three fields shortname of company, comany name and sales growth. for ex Inf,Infosys,10.8 there is no unique field in my data set on which i can join and also there is no extra field defined like Industry as you defined in your dataset. so can you give me idea how to achieve this ??

Re: Grouping of data

sunny_talwar — Mon, 10 Aug 2015 11:20:15 GMT

What determines a competitor in that case? In your above example you told us that Industry determined the competitor, hence we used that to join. Once you know what determines a competitor, you will join the competitors using that field.

Does that make sense?