Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inline Load with IF function?

Hi,

is it possible to integrate an IF function into an Inline Load?

Following scenario:

I have different kind of dates, i.e. created, modified, start, end etc.

I want to concatenate all these into one "calendar" (see below)

Month(Date(Date#(ows_Modified,'YYYY-MM-DD hh:mm:ss'),'MM/YYYY')) as DateMonth,

Month(Date(Date#(ows_Created,'YYYY-MM-DD hh:mm:ss'),'MM/YYYY')) as DateMonth

...

Problem: If I select "May" I see the right reportname, but I don't know if it is the modified or created date.

So I thought of creating an inline table like this below (pseudocode):

INPUT:

LOAD * Inline [

heading

IF(StartDate<>0,start,"")

IF(CreateDate<>0,created,"")

IF(ModifiedDate<>0,modified,"")

IF(EndDate<>0,end,"")

IF(CompleteDate<>0,completed,"") 

];

Perhaps my thoughts are too complicated and there is an easier solution?!

Thankful for any help,

Dave

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Hi,

     I dont know with what way you are concatenating the master calanders. But you can try something shown below.

     All you have to do is create a flag, which says from where the respective data has came.

     For example.

     MasterCal:

     Load StartDate as Date,

              'Start Date' as Flag

     Resident ABC;

     Concatenate

    

     Load EndDate as Date,

              'End Date' as Flag

     Resident PQR;

      Concatenate

    

     Load Create_Date as Date,

              'Create Date' as Flag

     Resident XYZ;

     And so on.

     Hope this is clear to you.

Regards,

Kaushik Solanki    

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

3 Replies
MVP & Luminary
MVP & Luminary

Hi,

     I dont know with what way you are concatenating the master calanders. But you can try something shown below.

     All you have to do is create a flag, which says from where the respective data has came.

     For example.

     MasterCal:

     Load StartDate as Date,

              'Start Date' as Flag

     Resident ABC;

     Concatenate

    

     Load EndDate as Date,

              'End Date' as Flag

     Resident PQR;

      Concatenate

    

     Load Create_Date as Date,

              'Create Date' as Flag

     Resident XYZ;

     And so on.

     Hope this is clear to you.

Regards,

Kaushik Solanki    

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Master II
Master II

try like this using if condition  throgh inline load

load IF(StartDate<>0,start,"") ,* inline [

StartDate,Start

];

Not applicable

Thanks to you! Both solutions are working but Kaushik' s one is the best for my problem!