How to associate the date field from 3 data files?

[ritaaguiar]

Hi there,

I have a Qlik Sense with three .txt data files. Each of the .txt data files has three fields in commom: Utilizador (Username), Data (Date), and Programa (Program).

I woould like to have a field block on my sheet which filters all graphics with data from any of these three files.

How can I get a date field which merges all three and thus affects all graphics from any of the 3 data files?

 

 You may notice that the Username field (Utilizador) and the Program field (Programa) are both successfully filtering all graphics. I would like that to happen to the date field as well.

I have tried to associate the Date fields but everytime I try that it dissassociates the other Username and Program fields...

[pradosh_thakur]

That's wonderful. Were you able to convert the dates into proper dates? You want me to look into it or not?

I am happy that you were able to do it.

[ritaaguiar]

@pradosh_thakur 

I'm not sure what you understand by coverting dates into proper dates, but if it is about having the calendar icon associated (and the associated fields that come with it), not yet. I found this post here on the community https://community.qlik.com/t5/New-to-Qlik-Sense/Problem-with-creating-calendar-measure-No-date-field... and it seems like it is not possible when data comes from the data load editor. It says that it is not possible to create calendar measures when dates come from the data load editor, and no one points any way of converting the dates from the data load editor into proper dates for the purpose of creating such calendar measures.

[pradosh_thakur]

@ritaaguiar  It doesn't matter if the calander icon is there or not. Just put  =max(date_field)  in a text box and tell me what you see. If you see a number it is all and good. If null your dates are text and not really dates.

Let me know

Regards

Pradosh

[ritaaguiar]

@pradosh_thakur 

Yup, I get a number

[pradosh_thakur]

You are good to go @ritaaguiar  . Well done on this.  I hope you learn many things and keep contributing.

[ritaaguiar]

@pradosh_thakur  I hope that too!

[pradosh_thakur]

I guess you can close this thread. 😄  Unless you are still looking for something else

[ritaaguiar]

@pradosh_thakur  Yes, the date fields are finally okay!

I have other issues with measures and what not, but it doesn't fit this question.

[pradosh_thakur]

Feel free to tag me to those post. I will be more than happy to help.