topic Re: Why isn't pie chart showing right data? in QlikView https://community.qlik.com/t5/QlikView/Why-isn-t-pie-chart-showing-right-data/m-p/1242946#M394552 <HTML><HEAD></HEAD><BODY><P>You can create a new field in the load statement and use the new field in Dimension.</P><P>As suggested by Wallo, you can use Calculated dimension.</P></BODY></HTML> Thu, 26 Jan 2017 19:17:24 GMT krishnacbe 2017-01-26T19:17:24Z Why isn't pie chart showing right data? https://community.qlik.com/t5/QlikView/Why-isn-t-pie-chart-showing-right-data/m-p/1242943#M394549 <HTML><HEAD></HEAD><BODY><P>I'm trying to separate data from US based employees and International. For US based employees, they are listed as "US" and all else I want to show as "International" this is whats in my expressions:&nbsp; </P><P>=if(SOURCE='HR data' and Emp Company = 'United States', 'US', 'International')</P><P></P><P>this expression used to work, but when i reloaded this happened. </P><P></P><P>TIA</P></BODY></HTML> Thu, 26 Jan 2017 18:05:10 GMT https://community.qlik.com/t5/QlikView/Why-isn-t-pie-chart-showing-right-data/m-p/1242943#M394549 2017-01-26T18:05:10Z Re: Why isn't pie chart showing right data? https://community.qlik.com/t5/QlikView/Why-isn-t-pie-chart-showing-right-data/m-p/1242944#M394550 <HTML><HEAD></HEAD><BODY><P>Can you share a sample app to look into or post snapshots of the issue that is not right ?</P></BODY></HTML> Thu, 26 Jan 2017 18:09:31 GMT https://community.qlik.com/t5/QlikView/Why-isn-t-pie-chart-showing-right-data/m-p/1242944#M394550 vishsaggi 2017-01-26T18:09:31Z Re: Why isn't pie chart showing right data? https://community.qlik.com/t5/QlikView/Why-isn-t-pie-chart-showing-right-data/m-p/1242945#M394551 <HTML><HEAD></HEAD><BODY><P>I think you would want that in as a calculated dimension.</P></BODY></HTML> Thu, 26 Jan 2017 18:10:49 GMT https://community.qlik.com/t5/QlikView/Why-isn-t-pie-chart-showing-right-data/m-p/1242945#M394551 Anonymous 2017-01-26T18:10:49Z Re: Why isn't pie chart showing right data? https://community.qlik.com/t5/QlikView/Why-isn-t-pie-chart-showing-right-data/m-p/1242946#M394552 <HTML><HEAD></HEAD><BODY><P>You can create a new field in the load statement and use the new field in Dimension.</P><P>As suggested by Wallo, you can use Calculated dimension.</P></BODY></HTML> Thu, 26 Jan 2017 19:17:24 GMT https://community.qlik.com/t5/QlikView/Why-isn-t-pie-chart-showing-right-data/m-p/1242946#M394552 krishnacbe 2017-01-26T19:17:24Z