As of Date in EBS using Qlikview

[kkkumar82]

Hi All,

I am creating a report where a date will be input using an input box, based on that we need to find the active employees as per the following EBS tables start and end dates

The main table here is assignments, where person_id's are there.

Let us assume we have selected a person_id or employee number and a date in input box, the report should shown the "active" data from other tables between the "effective dates" .

For now I have given one personID information with all the tables required.

Attaching the qvw with a simple data model.

Thanks

Kiran Kumar

[sunny_talwar]

Can you give an example of the output you would see based on an input date? I guess give a date to enter in the input box and provide a little more explanation about what the expected output needs to look like

[kkkumar82]

Sure,

for example if you give a date in the input box ,

1. the table should take the record from assignments table where the "input date" falls in between the assignments.startdate and assignments.end date

2. and for getting the record from people table , it is also having the effective start date and end date , the "input date"

should fall in that range also.

3. for other tables if you see the division and functionvalue for eg are changing based on the assignments table record

    the table should show those values as per the "effective dates"

I have data for one employee

Hope I made you clear

[sunny_talwar · Accepted solution]

I am not 100% sure, but can you check if this is what you want

[kkkumar82]

Hi Sunny,

for this sample its looking fine, but how remove the 1 or 0 from the straight table.

[sunny_talwar]

On the presentation tab, do two things

1) Suppress Zero Values

2) Hide your expression column

[kaushiknsolanki]

Hi,

Go to Properties -> Presentation Tab -> Click on the Expression (If.....) Click on Hide Column.

Click Ok.

Regards,

Kaushik Solanki

[kkkumar82]

I will let you with my original data thanks a lot for your immediate response

[sunny_talwar]

No problem brother.... I did see the post, but EBS threw me off. I guess next time give easy names to your post, else lazy people like me will ignore them

[sunny_talwar]

Check if this helps Kiran