Qlik Community

Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

Highlighted
guitartrova
Contributor 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



Tags (1)
3 Replies
thiago_justen
Valued Contributor III

Re: Synchronize dates of two tables

Mario,

Take a look here:

Re: Integrar Datas

Canonical Date

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
guitartrova
Contributor III

Re: Synchronize dates of two tables

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
Valued Contributor III

Re: Synchronize dates of two tables

Are you able to share a mock up?

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