topic Display all corresponding values ? Which function to use? Straight Table in QlikView https://community.qlik.com/t5/QlikView/Display-all-corresponding-values-Which-function-to-use-Straight/m-p/325109#M119766 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have three fields Job, Tasks, Tasks.Closed Date.</P><P></P><P>eg.</P><P>JobID, Tasks, Tasks.Closeddate</P><P>A,1, 9/8/2011</P><P>A, 2, 15/8/2011</P><P>A,3, 20/8/2011</P><P></P><P>This table is connected to anaother table Table2 through JobID. Table 2 contains ManagerName for any date. Table2 is connected to master calender.</P><P></P><P>So each job has many tasks and each tasks has its tasks.closeddate. I want my user to select any task (eg. A) and then I want to display the managers on each closed date. </P><P></P><P>So, there is master calender where i can connect as, task.closeddate=Calender. MasterDate. So that I can get the manager name on that corresponding date.</P><P></P><P>How to write an expression in a straight table, where I can give my dimensions as JobID, Tasks, Task.Closed date and it will display a manager name correspoding to each task.closeddate.?</P><P></P><P>Thanks. Any help would be appreciated.</P></BODY></HTML> Mon, 10 Oct 2011 17:14:59 GMT 2011-10-10T17:14:59Z Display all corresponding values ? Which function to use? Straight Table https://community.qlik.com/t5/QlikView/Display-all-corresponding-values-Which-function-to-use-Straight/m-p/325109#M119766 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have three fields Job, Tasks, Tasks.Closed Date.</P><P></P><P>eg.</P><P>JobID, Tasks, Tasks.Closeddate</P><P>A,1, 9/8/2011</P><P>A, 2, 15/8/2011</P><P>A,3, 20/8/2011</P><P></P><P>This table is connected to anaother table Table2 through JobID. Table 2 contains ManagerName for any date. Table2 is connected to master calender.</P><P></P><P>So each job has many tasks and each tasks has its tasks.closeddate. I want my user to select any task (eg. A) and then I want to display the managers on each closed date. </P><P></P><P>So, there is master calender where i can connect as, task.closeddate=Calender. MasterDate. So that I can get the manager name on that corresponding date.</P><P></P><P>How to write an expression in a straight table, where I can give my dimensions as JobID, Tasks, Task.Closed date and it will display a manager name correspoding to each task.closeddate.?</P><P></P><P>Thanks. Any help would be appreciated.</P></BODY></HTML> Mon, 10 Oct 2011 17:14:59 GMT https://community.qlik.com/t5/QlikView/Display-all-corresponding-values-Which-function-to-use-Straight/m-p/325109#M119766 2011-10-10T17:14:59Z