topic Stuck with Market selection in QlikView

Stuck with Market selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I have one issue that when I GL_Market_DIV as Regulated then I don't below regions

Africa

Asia

CIS

Middle East

South America

West Indies

But It is showing Please tell me how can i do this

Expected output when select GL_Market_DIV as Regulated

Re: Stuck with Market selection

Anonymous — Fri, 17 Mar 2017 10:56:49 GMT

select Market_Segmnt = Regulated Market instead to get that output.

Re: Stuck with Market selection

Anonymous — Fri, 17 Mar 2017 11:03:44 GMT

Hi Deran,

I know when i select Market_Segmnt = Regulated then i will get output but I want from GL_Market_DIV the desire outpout

Re: Stuck with Market selection

Anonymous — Fri, 17 Mar 2017 11:20:04 GMT

gwassenaar‌ / ALL

Any ideas???

Re: Stuck with Market selection

rahulpawarb — Fri, 17 Mar 2017 11:39:55 GMT

Hello Vijay,

Table DIM_QV_Customer is connected with VALUE_ENTRY table based on Customer_Code field; DIM_Division_Master table is linked with VALUE_ENTRY table on Div_Code field. As per my observation DIM_Division_Master table has inconsistent Customer_Code values against Div_Code compared with Table DIM_QV_Customer. Therefore it is not showing expected results.

You can get expected results by applying INNER JOIN with Table DIM_QV_Customer while loading DIM_Division_Master table.

Hope this will be helpful.

Regards!
Rahul

Re: Stuck with Market selection

Anonymous — Fri, 17 Mar 2017 12:08:25 GMT

Hi Rahul,

Can You please help out.

Thanks

Re: Stuck with Market selection

rahulpawarb — Mon, 20 Mar 2017 04:23:51 GMT

Hello Vijay,

Looking into it. Soon I will provide you updates.

Thank you!

Rahul

Re: Stuck with Market selection

rahulpawarb — Mon, 20 Mar 2017 06:07:46 GMT

Hello Vijay,

Based on provided data files I have prepared a draft version of sample application. Please refer the attachments.

BTW, joining two different tables may result into data loss. Be cautious while applying a join.

Regards!

Rahul