topic Re: 4 values into one in QlikView https://community.qlik.com/t5/QlikView/4-values-into-one/m-p/417695#M485037 <HTML><HEAD></HEAD><BODY><P>Brilliant, just what i needed!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> Thank you</P></BODY></HTML> Wed, 01 May 2013 18:06:21 GMT 2013-05-01T18:06:21Z 4 values into one https://community.qlik.com/t5/QlikView/4-values-into-one/m-p/417693#M485035 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>it is possible to make 4 different values into one?</P><P></P><P>eg on the picture i have 4 Closed values. </P><P></P><P>IS it possible to make one value called Closed which is a sum of them all??</P><P></P><P>Expression is atm.</P><P></P><P>=count({1&lt;DimPotentialCustomers.RelationID=p({1&lt;DimPotentialCustomers.RelationID={'11', '13','14','16','10','12'}&gt;} DimPotentialCustomers.RelationID)&gt;} DimPotentialCustomers.Company)</P><P></P><P><IMG __jive_id="40209" class="jive-image-thumbnail jive-image" onclick="" alt="crm1.PNG" src="https://community.qlik.com/legacyfs/online/40209_crm1.PNG" width="450" /></P></BODY></HTML> Wed, 01 May 2013 17:30:33 GMT https://community.qlik.com/t5/QlikView/4-values-into-one/m-p/417693#M485035 2013-05-01T17:30:33Z Re: 4 values into one https://community.qlik.com/t5/QlikView/4-values-into-one/m-p/417694#M485036 <HTML><HEAD></HEAD><BODY><P>Replace your chart dimenension with calculated dimensions, like this:</P><P>aggr((if(wildmatch(YourDimension, 'Closed*'), 'Closed', YourDimension), YourDimension)</P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Wed, 01 May 2013 17:39:27 GMT https://community.qlik.com/t5/QlikView/4-values-into-one/m-p/417694#M485036 Anonymous 2013-05-01T17:39:27Z Re: 4 values into one https://community.qlik.com/t5/QlikView/4-values-into-one/m-p/417695#M485037 <HTML><HEAD></HEAD><BODY><P>Brilliant, just what i needed!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> Thank you</P></BODY></HTML> Wed, 01 May 2013 18:06:21 GMT https://community.qlik.com/t5/QlikView/4-values-into-one/m-p/417695#M485037 2013-05-01T18:06:21Z