topic Re: data joining in QlikView

data joining

Mon, 11 Jan 2016 16:18:24 GMT

HI All

i have two a sales table (both have all same common fields)

1)i am taking sales based on Product Group table(sheet1)

2)now i need to include few sales based on product number table(sheet2)

i concatenated the sales in the dashboard

Product number is a drill drown group of Product Group

example

Product Group product number Product Group Name

241 241321 Womens

241 241322 Womens

241 241323 Womens

241 241324 Womens

241 241325 Womens

241 241326 Womens

there is a Common field between Product Group table and product number table Product Group Name

in the dash board list box if i choose Product Group name men

both sales common for Product Group Name should appear,

how to get this, please Suggest

Re: data joining

sunny_talwar — Mon, 11 Jan 2016 16:22:28 GMT

There is no Product Group 241 in your attached Excel file (Sheet1)

Is that missing by mistake or that's how the data is?

Re: data joining

Mon, 11 Jan 2016 16:29:20 GMT

HI Sunny

this is how the data is actually

need only sales for few product numbers for the Product Group 241

Re: data joining

sunny_talwar — Mon, 11 Jan 2016 16:35:31 GMT

But there isn't any Product Group 241 in your data provided?

Re: data joining

Mon, 11 Jan 2016 16:43:48 GMT

HI Sunny

the sheet 2 is for product group 241

but actually there are more than 100 product numbers fall under the Product Group 241

but only need the sales for 25 product numbers in sheet 2

(actual requirement is to see all the sales for (women) including Sales picked by sheet 1 and Sheet 2)

Please Suggest

Re: data joining

sunny_talwar — Mon, 11 Jan 2016 16:46:57 GMT

May be concatenate sheet2 into sheet 1 where you can use

Concatenate (Sheet1)

LOAD Left([Product Number], 3) as [Product Group],

[Product Number],

Channels

FROM Sheet2

Where Match([Product Number], .....);

Re: data joining

Mon, 11 Jan 2016 17:04:35 GMT

HI Sunny

actually 241321

241322

these first 3 digits are not the Product Group i created it in that format as example

Re: data joining

sunny_talwar — Mon, 11 Jan 2016 17:08:05 GMT

I am not really sure I understand what you are trying to do. Can you try re-explaining your requirement?

Re: data joining

Mon, 11 Jan 2016 17:31:33 GMT

I really didn't understand...

What do you want? Do you have I real database?

If you just want to click in WOMAN and QV show all sales for woman including sheet2 the base is wrong...

You can do all calculations in QV, don't need the "sheet2".

But check this .qvw, I don't know if it is what you want.

Giba

Re: data joining

Mon, 11 Jan 2016 17:46:26 GMT

HI Sunny

i will explain it clearly

Re: data joining

Mon, 11 Jan 2016 18:41:08 GMT

John,

Your data tables are not designed such that you can make any meaningful relationship between them.