Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Get Unique dates from Multiple columns ending in same substring

I have a set of columns in the data with column name ending in same string like

Column1_Date,Column2_date ..........

_date remains same in multiple column names and others columns exist in between.

I need to create a filter for dates with unique month from all the columns.

eg:

Column1_date    |  Column2_date

------------------------------------------------------

        Jan-20                |            Feb-20

        Feb-20                |            Apr 20

       Mar-20                 |            Jan-20

---------------------------------------------------

 

The filter  should contain all 4 months : 

filter

----------

Jan-20

Feb-20

Mar-20

Apr-20

Labels (2)
3 Replies
Highlighted
Master
Master

Maye be :

Data:
load * inline [
Column1_date,Column2_date
Jan-20,Feb-20
Feb-20,Apr 20
Mar-20 ,Jan-20
];


    FOR fieldno=1 TO NoOfFields('Data')

      fieldname = FieldName(fieldno,'Data');

    Filtre: load distinct filtre; LOAD $(fieldname) as filtre Resident Data;

    NEXT

 

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Highlighted
Contributor
Contributor

I tried using this with data loaded from excel but not getting processed

Highlighted
Master
Master

can you share the excel sample ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉