Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

selected row higlight

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

qlikview.jpg

thank you

4 Replies
Highlighted
jebamalai
Valued Contributor

Re: selected row higlight

check your datamodel whether all the tables are connected fine

Highlighted
Not applicable

Re: selected row higlight

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)

Highlighted
jebamalai
Valued Contributor

Re: selected row higlight

for me it looks like the issue with the concatenated field

can you share a sample qv app?

Highlighted
Not applicable

Re: selected row higlight

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