topic Re: To take only one value in QlikView https://community.qlik.com/t5/QlikView/To-take-only-one-value/m-p/613037#M1117597 <HTML><HEAD></HEAD><BODY><P>Looks like there are duplicated rows in your data model.</P><P>Try to use </P><P>Load Distinct</P><P>While Loading the data.</P></BODY></HTML> Thu, 06 Feb 2014 07:19:46 GMT MK_QSL 2014-02-06T07:19:46Z To take only one value https://community.qlik.com/t5/QlikView/To-take-only-one-value/m-p/613033#M1117593 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>I had a straight table in which 1 value is repeating for 2 regions ,but in which i want to show only value.Please see attached screen shot.</P></BODY></HTML> Thu, 06 Feb 2014 07:07:31 GMT https://community.qlik.com/t5/QlikView/To-take-only-one-value/m-p/613033#M1117593 polisetti 2014-02-06T07:07:31Z Re: To take only one value https://community.qlik.com/t5/QlikView/To-take-only-one-value/m-p/613034#M1117594 <HTML><HEAD></HEAD><BODY><P>try with</P><P>sum(distinct&nbsp; yourfield)</P></BODY></HTML> Thu, 06 Feb 2014 07:10:26 GMT https://community.qlik.com/t5/QlikView/To-take-only-one-value/m-p/613034#M1117594 maxgro 2014-02-06T07:10:26Z Re: To take only one value https://community.qlik.com/t5/QlikView/To-take-only-one-value/m-p/613035#M1117595 <HTML><HEAD></HEAD><BODY><P>You most likely have a problem in your data model; a problem that creates these duplicates. So, fix your data model.</P><P></P><P>Sum(distinct ...) may work, but is a bad solution. It removes the symptom but not the problem. </P><P></P><P>HIC</P></BODY></HTML> Thu, 06 Feb 2014 07:15:00 GMT https://community.qlik.com/t5/QlikView/To-take-only-one-value/m-p/613035#M1117595 hic 2014-02-06T07:15:00Z Re: To take only one value https://community.qlik.com/t5/QlikView/To-take-only-one-value/m-p/613036#M1117596 <HTML><HEAD></HEAD><BODY><P>I alreay tried it but the value in total is not matching .i need to show total as 5000 but it is getting less value.</P></BODY></HTML> Thu, 06 Feb 2014 07:18:26 GMT https://community.qlik.com/t5/QlikView/To-take-only-one-value/m-p/613036#M1117596 polisetti 2014-02-06T07:18:26Z Re: To take only one value https://community.qlik.com/t5/QlikView/To-take-only-one-value/m-p/613037#M1117597 <HTML><HEAD></HEAD><BODY><P>Looks like there are duplicated rows in your data model.</P><P>Try to use </P><P>Load Distinct</P><P>While Loading the data.</P></BODY></HTML> Thu, 06 Feb 2014 07:19:46 GMT https://community.qlik.com/t5/QlikView/To-take-only-one-value/m-p/613037#M1117597 MK_QSL 2014-02-06T07:19:46Z