topic Sort by Expression with nested ifs combined with set analysis not working in QlikView https://community.qlik.com/t5/QlikView/Sort-by-Expression-with-nested-ifs-combined-with-set-analysis/m-p/436213#M559134 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a solution where I have a pivot table with my clients and their revenue. The total on this table is sorted depending on what radio button is selected.</P><P>At first it looked like it was working fine, until I noticed that if a given client did have any revenue on the month selected, even if he is a top client, it's not showing in my sort. What I found out was that the client I needed in the top 10 was way down the list even though my sort is sorting by YTD.</P><P></P><P> Please see document attached for more information.</P><P></P><P>Could anyone help with this issue as I'm stuck on it for the last 3 days and I can't find anything in the community that resolves my problem.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 08 May 2013 01:50:37 GMT drjoffily 2013-05-08T01:50:37Z Sort by Expression with nested ifs combined with set analysis not working https://community.qlik.com/t5/QlikView/Sort-by-Expression-with-nested-ifs-combined-with-set-analysis/m-p/436213#M559134 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a solution where I have a pivot table with my clients and their revenue. The total on this table is sorted depending on what radio button is selected.</P><P>At first it looked like it was working fine, until I noticed that if a given client did have any revenue on the month selected, even if he is a top client, it's not showing in my sort. What I found out was that the client I needed in the top 10 was way down the list even though my sort is sorting by YTD.</P><P></P><P> Please see document attached for more information.</P><P></P><P>Could anyone help with this issue as I'm stuck on it for the last 3 days and I can't find anything in the community that resolves my problem.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 08 May 2013 01:50:37 GMT https://community.qlik.com/t5/QlikView/Sort-by-Expression-with-nested-ifs-combined-with-set-analysis/m-p/436213#M559134 drjoffily 2013-05-08T01:50:37Z