topic Re: Selecting Particular date in QlikView

Selecting Particular date

Fri, 04 Sep 2015 11:09:28 GMT

Hi All,

I have a table with MS_Date. Where each Milestone has some MS_Date.

In the attached QVW you can find the Table where the expressions are milestones.

I need to display MS_Date based on Milestone

Ex. If Milestone is EMD then respective date should be displayed in the next column.

If Milestone is ADV then respective date should be displayed in the next column. and so on

Please help me what condition has to be written.

Regards,

Keerthi KS

Re: Selecting Particular date

jonathandienst — Fri, 04 Sep 2015 11:23:03 GMT

I am sorry - this does not explain much even after looking at your qvw. What do you mean by "Milestone is EMD"? How do you want to display MS_Date? What and where is the "next column"?

Re: Selecting Particular date

Fri, 04 Sep 2015 11:27:21 GMT

EMD is one Milestone. I have Many milestones in the table. All the expressions in the table are Milestones

Each Milestone is one transaction with MS_Date.

In the table you can see EMD next to it i should have MS_Date. MS_Date of EMD transaction.

Please let me know if its not clear.