How selected value of a date filter could be reused in two different date dimensions?
I’m new to Qlik Sense. I’m working to prepare Sales reporting.
I have a table with sales order information, including booking date, and a table with billings information, including an billing date. The two tables are linked by an ID_Mission field. No problems so far.
I would like to have a unique filter that would allow to filter on Year and this selected year would be reused as dimension on graphics that are in different sheets using either Booking date or Billing date.
I would select eg 2015 once for all, and moving from sheet to another, it would filter on 2015 Booking Dates or on 2015 Billing dates, depending on the graphs. It would save having to cancel the unappropriated filter and select another.
I’ve tried to use the GetFieldSelections with no luck. I succeeded in retrieving the year selection, but I can’t find a way to pass that value to the SaleDate dimension or to the BillingDate dimension which I use in my graphs.
Re: How selected value of a date filter could be reused in two different date dimensions?
Many thanks for your help on this. Your proposal did work and I’m now able to filter by using a unique dimension YearMonth and my different graphs are using the BookingDate or BillingDate appropriately. Thanks again!
I’ve been able to load the year data from your script, but I’ve not been able to load Month in the same load… I had to do year and month separately. There is probably room for optimisation, if someone as ideas on this…
I'm also not sure about the way the newly created table is named, and how to give it a name I choose.