Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rperezlaso
Contributor III
Contributor III

filtering Panel global time?

Hi good morning,

I have the following problem:

  • I have products with different times in the same table::
    • id_product
    • time_station_1_line1
    • desc_1_line_1
    • time_station_1_line2
    • desc_2_line2

    • time_station_2_line1
    • desc_2_line1
    • time_station_2_line2
    • desc_2_line2
  • I need a filtering panel per global day, this is how I solve it (I am aware that this is wrong): :
    • day(time_station_1).
  • One of the problems I have is that when I filter for example on day 1 there are records that I lose because there are products that pass through either line 1 or line 2.

ex:

product a223 -> time_station1 line 2 -> time_station2 line 2

product a224 -> time_station1 line 1 -> time_station 2 line 1

2 Replies
OmarBenSalem

Please refer to this:

Canonical Date

rperezlaso
Contributor III
Contributor III
Author

I do not understand how to apply it