topic Re: How to write expression in straight or pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552476#M1142149 <HTML><HEAD></HEAD><BODY><P>Please can anyone help me as it is urgent</P></BODY></HTML> Mon, 23 Sep 2013 09:21:47 GMT 2013-09-23T09:21:47Z How to write expression in straight or pivot table https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552475#M1142148 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I need to create one straight table or pivot table. I need to get Sum(Amount) where ActualID=AccountID. for each individual employee. The dimension is EmployeeID. But this EmployeeID and Amount are from one table, whereas ActualID is from another table.</P><P></P><P>Could any one help me how to write the expression please as it is urgent for me please</P><P></P><P></P><P>Thanks.</P></BODY></HTML> Mon, 23 Sep 2013 08:40:33 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552475#M1142148 2013-09-23T08:40:33Z Re: How to write expression in straight or pivot table https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552476#M1142149 <HTML><HEAD></HEAD><BODY><P>Please can anyone help me as it is urgent</P></BODY></HTML> Mon, 23 Sep 2013 09:21:47 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552476#M1142149 2013-09-23T09:21:47Z Re: How to write expression in straight or pivot table https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552477#M1142150 <HTML><HEAD></HEAD><BODY><P>Hi Amelia</P><P></P><P>Greetings.</P><P></P><P>Kindly let us know whether there is any relationship between the two tables ..If there is no relationship you cannot write an expression.</P><P></P><P>The other option that is available is you can create an link table and then write an expression</P><P></P><P>To know more about link tables you can refer this links</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/thread/71740">http://community.qlik.com/thread/71740</A></P><P><A _jive_internal="true" href="https://community.qlik.com/thread/72940">http://community.qlik.com/thread/72940</A></P></BODY></HTML> Mon, 23 Sep 2013 10:17:33 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552477#M1142150 2013-09-23T10:17:33Z Re: How to write expression in straight or pivot table https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552478#M1142151 <HTML><HEAD></HEAD><BODY><P>Have you tried : Sum(If(ActualID=AccountID, Amount)) ?&nbsp; If this does not work, please share a sample app.</P></BODY></HTML> Mon, 23 Sep 2013 10:38:26 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552478#M1142151 tresB 2013-09-23T10:38:26Z Re: How to write expression in straight or pivot table https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552479#M1142152 <HTML><HEAD></HEAD><BODY><P>Thanks it's not working. could you help me please as I am not getting any idea please.</P></BODY></HTML> Mon, 23 Sep 2013 11:22:57 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552479#M1142152 2013-09-23T11:22:57Z Re: How to write expression in straight or pivot table https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552480#M1142153 <HTML><HEAD></HEAD><BODY><P>The above expression will work only if the tables are linked..Else it wont work</P><P></P><P>Create a link table and try with above expression from tresesco then it may work..</P></BODY></HTML> Mon, 23 Sep 2013 12:12:19 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552480#M1142153 2013-09-23T12:12:19Z Re: How to write expression in straight or pivot table https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552481#M1142154 <HTML><HEAD></HEAD><BODY><P>I suggest that you provide more information, preferably your model with some sample data loaded, or at least an idea of the structure of your model.</P><P></P><P>Also, please explain "not working" - does this mean it return nothing (null), or returns an unexpected value. This information will make it easier for people to help you.</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Mon, 23 Sep 2013 12:45:55 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552481#M1142154 jonathandienst 2013-09-23T12:45:55Z Re: How to write expression in straight or pivot table https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552482#M1142155 <HTML><HEAD></HEAD><BODY><P>Thanks and I created link table but still it's showing zero values . could you let me know is do I need to change in Link table</P></BODY></HTML> Mon, 23 Sep 2013 14:04:39 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552482#M1142155 2013-09-23T14:04:39Z Re: How to write expression in straight or pivot table https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552483#M1142156 <HTML><HEAD></HEAD><BODY><P><BR />Please attach a screenshot of your data model along with a set of dummy data so that it will be easy for us to help you.</P></BODY></HTML> Mon, 23 Sep 2013 14:20:24 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression-in-straight-or-pivot-table/m-p/552483#M1142156 2013-09-23T14:20:24Z