Discussion board where members can get started with Qlik Sense.
i got a question, i have 2 columns;
i want to know, is that possible to combine 2 columns into one, if it is possible, how can i concatenate the combined column with my maser calender?
does anybody have any idea?
Not sure the exact need but you may think of like this:
Load StartDate as Date
Load EndDate as Date
Now you can find Max and Min Date and create master calendar out of your Date column.
thanks a lot for your responce and help,
i have a question, as you see i have two columns and i want to compare two columns, for instance:
if (02.02.2015 < 02.12.2017, 'non active', 'active') as State,
can i create such field: State and later combine two columns into one.
Load CalendarDate as Temp_Date
// Single Column to have extract of Start and End Dates
Temp_Date as Single_Date
where Temp_Date>=StartDate and TempDate<=EndDate;
Now if you need to find the Min Date and Max Date for the Primary Keys. -- . Just use the Min(Single_Date) and Max(Single_Date).
you could also use count(distinct Single_Date) to find the days between.
We have got the same problem and i have did this and got the solution .
Please let me know if this works.
first of all thanks a lot for your responce and time:
my issue is: 1) i want to create the Field: State, the Idea is: to those columns belong the projects, i want to show, that the project until certain date is active and non active, therefore i want to create the Field: State
2) then i want to create the Filter: State and can select and show on the time line my active and non active project.
is that clear explained?
Thanks a lot
to me, if that's what you are looking
load * inline [
if (StartDate < EndDate, 'non active', 'active') as State
Drop table QCtemp;