topic Re: Please suggest in QlikView

Please suggest

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

Hi All,

I have 5 tables in the data model and it forms too many syn keys.

In order to resolve these, I have created composite keys

but missing some filters(brand, country, info_year..) and getting

some non appropriate results in some reports/KPIs)

That would be great If you can suggest any other ways to resolve.

below are for your reference.

table1 contains below fields

Country

zone

year

Volume(measure)

table2 contains

Country

brand

info_year

info_start_year

info_Volume(measure)

table3 contains

Country

brand

volume3(measure)

table4 contains

Country

brand

info_year

KPI_Volume(measure)

table5 contains

brand

info_year

revenue(measure)

Please help me out in this.

any help will be appreciated.

Re: Please suggest

YoussefBelloum — Thu, 08 Mar 2018 14:55:39 GMT

Hi,

what is the joining key between those tables ?

can you attach some rows of each table in an excel file ?

Re: Please suggest

Anonymous — Thu, 08 Mar 2018 14:59:22 GMT

Hello,

Kindly share the sample application

Thanks & regards,

Venkata Sreekanth

Re: Please suggest

antonybi — Thu, 08 Mar 2018 17:57:33 GMT

Thanks for response.

but unable to share the data as am working with actual data...

that's why I have created some dummy data which is as same as actual data.

kindly replay suggest me on this.

Re: Please suggest

zebhashmi — Thu, 08 Mar 2018 19:42:59 GMT

check Generic Key

Generic keys

Re: Please suggest

antonybi — Fri, 09 Mar 2018 04:13:51 GMT

Hi Thanks for response

am using personal edition. Kindly share the script so that I can able to see your script .