Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

divyanshi
New Contributor II

how to merge two columns and add corresponding date values?

I want to merge two columns and add corresponding dates so that when I apply it in filter...I got respective values?

9 Replies
techvarun
Valued Contributor II

Re: how to merge two columns and add corresponding date values?

Please share some sample data model and expected output to understand better.

divyanshi
New Contributor II

Re: how to merge two columns and add corresponding date values?

there is 1 table named 31st march which has band column with multiple values and same is with another table named 28th feb.

I want that there two columns appear in qilksense with changeable to date.

arvind_patil
Valued Contributor II

Re: how to merge two columns and add corresponding date values?

Hi Divyanshi,

Cloud you Provide Sample data so I will help in more interactively.

Thanks,

Arvind Patil

techvarun
Valued Contributor II

Re: how to merge two columns and add corresponding date values?

Capture the tablename in a list box and use the same as the filter.

techvarun
Valued Contributor II

Re: how to merge two columns and add corresponding date values?

sample.PNG

Something like this?

divyanshi
New Contributor II

Re: how to merge two columns and add corresponding date values?

sample data as @Varun Prakash Paulraj next to the reply....

divyanshi
New Contributor II

Re: how to merge two columns and add corresponding date values?

yes I want it as same but how in qilksense should I do ??

arvind_patil
Valued Contributor II

Re: how to merge two columns and add corresponding date values?

Hi Varun,

If You want to merge Band and Start Date in Single column then Like below:

LOAD .

.

.

BAND &'-'& [Statrt Date] as [Band  Start Date]

Thanks,

Arvind Patil

divyanshi
New Contributor II

Re: how to merge two columns and add corresponding date values?

ok but I have BAND-A and BAND-B ,then how to include both band values into a new column separately.

BAND-A               BAND-B

    U1                          U2

I want :

FINAL RESULT

     U1 + date

     U2 + date

May I able to make you understand ..

Community Browser