Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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.
Give the date fields in both tables the same name.
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.
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.
Ok thanks you very much, it works with the onSelect!