topic Re: Multiples tables and date filter in QlikView

Multiples tables and date filter

Tue, 24 Jun 2014 16:14:19 GMT

Dear all,

I have a new problem on QlikView, I have 2 tables : Ticket & Reporting.

Each table has a date field.

How I can have only one "selection list" to filter both table.

Thanks !

Re: Multiples tables and date filter

Gysbert_Wassenaar — Tue, 24 Jun 2014 16:17:24 GMT

Give the date fields in both tables the same name.

Re: Multiples tables and date filter

Tue, 24 Jun 2014 16:22:46 GMT

Hi Gysbert,

I already try that but since the table already have a common name (EntityId) that creates an synthetic key and give me a mess 😞

Ticket:

LOAD *,year(DateCreationTicket) as Année, MonthName(DateCreationTicket) as Mois;

SQL SELECT id as IdTicket,

entities_id as EntiteId,

type as TypeTicket,

name as TicketName,

itilcategories_id as Categorie,

date as DateCreationTicket,

status,

takeintoaccount_delay_stat as DelaiAssignation,

close_delay_stat as DelaiCloture,

solve_delay_stat as DelaiResolu,

date_format(date,'%m/%Y') as MoisAnneeTicket ,

to_days(date) as tridate

FROM glpi_tickets;

ReportingAlias:
LOAD *,year(r_period) as Année, MonthName(r_period) as Mois;
SQL select g.name as r_groupe,q.question as r_question,q.id as r_qid,q.seuil as r_seuil,r.value as r_realise,period as r_period,r.entity_id as EntiteId from prd_reporting.reporting r
inner join prd_reporting.questions q on r.question_id=q.id
inner join prd_reporting.groupe g on q.groupe=g.id;

And that loading script give me a syn key with Année, Mois and EntityID.

Re: Multiples tables and date filter

Gysbert_Wassenaar — Tue, 24 Jun 2014 16:27:24 GMT

If the date fields are very different things then giving the fields the same name doesn't make sense. You can try adding a Select in Field action to the OnSelect field trigger of one the date fields to select the same value in the other date field.

Re: Multiples tables and date filter

Tue, 24 Jun 2014 16:51:05 GMT

Ok thanks you very much, it works with the onSelect!