Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-09-04 07:09 AM

Selecting Particular date

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

Test.qvw
271 Views
0 Likes
2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III
‎2015-09-04 07:23 AM

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"?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
184 Views
0 Likes
Not applicable
‎2015-09-04 07:27 AM
Author

In response to jonathandienst

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.

184 Views
0 Likes