Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am new to qlikview and planning to use to to slect a primary key and higlight related rows in about 10 tables
this works in some case but does not in few others.
please advise
thank you
check your datamodel whether all the tables are connected fine
i am using just 4 tables and i connect them using a field ex: primary_id
2 of these tables do not have this field as is, so i create it concatination 2 fields(which looks correct)
my primary_id has all unique values in tables ( like a full outer join)
for me it looks like the issue with the concatenated field
can you share a sample qv app?
APP? yopu mean script i can send it over like it ..its almost the same,i use a relationl db as source
SQL SELECT
group_id as ns_group_id, ----MY PRIMARY KEY
group_id as ns_group_id_pk,
base_date as ns_base_date,
product_number as ns_product_number,
base_year_week_number as ns_year_week_number,
FROM "PLAY_PEN"."allgroups_key_d";
SQL SELECT
group_id as ns_group_id, ----MY PRIMARY KEY
group_id as cs_group_id,
base_date as cs_base_date,
product_number as cs_product_number,
base_year_week_number as base_year_week_number,
long_description as cs_long_description,
offer_end_date as cs_offer_end_date,
offer_end_week as cs_offer_end_week,
FROM "PLAY_PEN"."allgroups_key_d";
SQL SELECT
offer_number as promos_offer_number_ns,
product_number as promos_tpnb_ns,
trim(aaaa)||trim(bbbb) as ns_group_id, ----MY PRIMARY KEY
trim(aaaa)||trim(bbbb) as ns_group_id_fp,
long_description as ap_long_description_ns,
offer_start_date as ap_offer_start_date_ns,
offer_end_date as ap_offer_end_date_ns,
FROM "PLAY_PEN"."allfuture_groups_d";
SQL SELECT
offer_number as promos_offer_number_cs,
product_number as promos_tpnb_cs,
trim(aaaa)||trim(bbbb) as ns_group_id, ----MY PRIMARY KEY
trim(aaaa)||trim(bbbb) as cs_group_id_fp,
price as base_date_cs
FROM "PLAY_PEN"."allfuture_groups_d";
SQL SELECT
offer_number as offer_number_cs,
product_number as product_number_cs,
trim(aaaa)||trim(bbbb) as ns_group_id, ----MY PRIMARY KEY
trim(aaaa)||trim(bbbb) as group_id_cs_alp,
opted_in as opted_in_cs
FROM "PLAY_PEN"."allAll_groups_d";
SQL SELECT
offer_number as offer_number_ns,
product_number as product_number_ns,
trim(aaaa)||trim(bbbb) as ns_group_id, ----MY PRIMARY KEY
trim(aaaa)||trim(bbbb) as group_id_ns_alp,
ofr_offer_end_date as ofr_offer_end_date_ns
FROM "PLAY_PEN"."allAll_groups_d";