topic Sum, Distinct count with condition and percentage in QlikView https://community.qlik.com/t5/QlikView/Sum-Distinct-count-with-condition-and-percentage/m-p/983157#M335545 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>Thanks all for your help. Please suggest me a suitable solution here. Either in one table or two tables as possible i need sum, distinct count where sum of quantity is greater than 0 should be considered of particular month and percentage total sum / overall total.</P><P>Please check my attachment suppose if we select any particular field in the list box the value which we are getting in the text box and in the count field should be shown even if no selection of Ile_Ageing has been applied.</P><P></P><P></P><P>Any help is appreciated ! !</P></BODY></HTML> Mon, 07 Sep 2015 02:05:58 GMT rahulsud007 2015-09-07T02:05:58Z Sum, Distinct count with condition and percentage https://community.qlik.com/t5/QlikView/Sum-Distinct-count-with-condition-and-percentage/m-p/983157#M335545 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>Thanks all for your help. Please suggest me a suitable solution here. Either in one table or two tables as possible i need sum, distinct count where sum of quantity is greater than 0 should be considered of particular month and percentage total sum / overall total.</P><P>Please check my attachment suppose if we select any particular field in the list box the value which we are getting in the text box and in the count field should be shown even if no selection of Ile_Ageing has been applied.</P><P></P><P></P><P>Any help is appreciated ! !</P></BODY></HTML> Mon, 07 Sep 2015 02:05:58 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct-count-with-condition-and-percentage/m-p/983157#M335545 rahulsud007 2015-09-07T02:05:58Z