topic Re: How to show CASTIDs cancelled by? in QlikView https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615599#M1117211 <HTML><HEAD></HEAD><BODY><P>can you upload qvw file ?</P></BODY></HTML> Thu, 06 Feb 2014 12:00:25 GMT manojkulkarni 2014-02-06T12:00:25Z How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615590#M1117200 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have to show <STRONG>CASTIDs cancelledby person, team and item. </STRONG>Please can anyone help me with correct expression. as I used one but not sure whether it is correct or not?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 06 Feb 2014 11:01:57 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615590#M1117200 2014-02-06T11:01:57Z Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615591#M1117203 <HTML><HEAD></HEAD><BODY><P>Yeah its write due to your Id which is unique </P><P>so if you replace distinct keyword then doesn't affect</P><P></P><P>Count(distinct (IF(notes='cancelled',FFTID)))</P><P>or </P><P>Count(distinct (IF(notes='cancelled',FFTID)))</P><P>or try this if you aggr it for three column</P><P>Count(DISTINCT aggr(IF(notes='cancelled',FFTID)</P><P>,Team,person,Item))</P></BODY></HTML> Thu, 06 Feb 2014 11:12:53 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615591#M1117203 er_mohit 2014-02-06T11:12:53Z Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615592#M1117204 <HTML><HEAD></HEAD><BODY><P>Thanks and it is not showing the values correct when I complared the values in database. Do I need to change any thing?</P></BODY></HTML> Thu, 06 Feb 2014 11:26:32 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615592#M1117204 2014-02-06T11:26:32Z Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615593#M1117205 <HTML><HEAD></HEAD><BODY><P>use this in expression, Count(DISTINCT aggr(IF(notes='cancelled',ID),Team,person,Item))</P></BODY></HTML> Thu, 06 Feb 2014 11:33:41 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615593#M1117205 manojkulkarni 2014-02-06T11:33:41Z Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615594#M1117206 <HTML><HEAD></HEAD><BODY><P>Tell me what is actual output comes </P></BODY></HTML> Thu, 06 Feb 2014 11:35:49 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615594#M1117206 er_mohit 2014-02-06T11:35:49Z Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615595#M1117207 <HTML><HEAD></HEAD><BODY><P>Thanks and again the same problem . As in the database for person= RTY where ID=9 the count is 150. but in qvw it is showing 1. Any thing do I need to change?</P></BODY></HTML> Thu, 06 Feb 2014 11:37:55 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615595#M1117207 2014-02-06T11:37:55Z Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615596#M1117208 <HTML><HEAD></HEAD><BODY><P>I have to show this table in qvw.</P></BODY></HTML> Thu, 06 Feb 2014 11:39:33 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615596#M1117208 2014-02-06T11:39:33Z Re: Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615597#M1117209 <HTML><HEAD></HEAD><BODY><P>Pls find attachment with expected result</P></BODY></HTML> Thu, 06 Feb 2014 11:45:02 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615597#M1117209 manojkulkarni 2014-02-06T11:45:02Z Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615598#M1117210 <HTML><HEAD></HEAD><BODY><P>Thanks and i tried and again the same problem. is there any issue with expression?</P></BODY></HTML> Thu, 06 Feb 2014 11:59:02 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615598#M1117210 2014-02-06T11:59:02Z Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615599#M1117211 <HTML><HEAD></HEAD><BODY><P>can you upload qvw file ?</P></BODY></HTML> Thu, 06 Feb 2014 12:00:25 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615599#M1117211 manojkulkarni 2014-02-06T12:00:25Z Re: Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615600#M1117212 <HTML><HEAD></HEAD><BODY><P>i write on above is FFTID&nbsp; replace it by ID hope it gives you right answer</P></BODY></HTML> Thu, 06 Feb 2014 12:26:04 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615600#M1117212 er_mohit 2014-02-06T12:26:04Z Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615601#M1117213 <HTML><HEAD></HEAD><BODY><P>Thanks and I did the same but still the same error.</P></BODY></HTML> Thu, 06 Feb 2014 12:51:03 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615601#M1117213 2014-02-06T12:51:03Z Re: How to show CASTIDs cancelled by? https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615602#M1117216 <HTML><HEAD></HEAD><BODY><P>I attached the one which I did already in the starting QQ.qvw. please any solution for this?</P></BODY></HTML> Thu, 06 Feb 2014 12:51:45 GMT https://community.qlik.com/t5/QlikView/How-to-show-CASTIDs-cancelled-by/m-p/615602#M1117216 2014-02-06T12:51:45Z