I want to merge two columns and add corresponding dates so that when I apply it in filter...I got respective values?
Please share some sample data model and expected output to understand better.
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.
Capture the tablename in a list box and use the same as the filter.
Cloud you Provide Sample data so I will help in more interactively.
sample data as @Varun Prakash Paulraj next to the reply....
Something like this?
yes I want it as same but how in qilksense should I do ??
If You want to merge Band and Start Date in Single column then Like below:
BAND &'-'& [Statrt Date] as [Band Start Date]
ok but I have BAND-A and BAND-B ,then how to include both band values into a new column separately.
I want :
U1 + date
U2 + date
May I able to make you understand ..
Retrieving data ...