selected row higlight

Thu, 10 Sep 2015 12:24:05 GMT

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

Re: selected row higlight

Anonymous — Thu, 10 Sep 2015 12:34:45 GMT

check your datamodel whether all the tables are connected fine

Re: selected row higlight

Thu, 10 Sep 2015 13:17:37 GMT

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)

Re: selected row higlight

Anonymous — Thu, 10 Sep 2015 13:28:12 GMT

for me it looks like the issue with the concatenated field

can you share a sample qv app?

Re: selected row higlight

Thu, 10 Sep 2015 15:34:47 GMT

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";

topic Re: selected row higlight in QlikView

selected row higlight

Re: selected row higlight

Re: selected row higlight

Re: selected row higlight

Re: selected row higlight