Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MarioCenteno
Creator III
Creator III

Synchronize dates of two tables

Help me.


I need to synchronize the dates of two different tables, it happens that when I select the date F_IFR it shows me a value but if I select F_UCE it shows me another I want to join the two dates so that the data selection is unique.


Expression measure

SUM({<[F_IFR.autoCalendar.Year]={'$(vMaxYear)'},

[F_IFR.autoCalendar.Month]={'$(vMaxMonth)'},[F_IFR.autoCalendar.Day]={'<=$(vMaxDay)'},

F_IFR=,[F_IFR.autoCalendar.YearMonth]=>}SALES)

QLK1.png


qlk2.png



Labels (2)
3 Replies
Thiago_Justen_

Mario,

Take a look here:

Re: Integrar Datas

Canonical Date

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
MarioCenteno
Creator III
Creator III
Author

Hi Thiago

I followed your example but something I'm doing wrong, you could help me a little more please.


Now it does not show me data.


qlk3.png

Thiago_Justen_

Are you able to share a mock up?

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago