topic Conditional count of values from another object. Please? in QlikView https://community.qlik.com/t5/QlikView/Conditional-count-of-values-from-another-object-Please/m-p/369253#M575105 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I was wondering if anyone would have any advice about how do the following, please.</P><P></P><P>I´ve got a straigt table where dimension is Number of Risks from 1 to 30 for example and then expressions are if formulas. </P><P>Eg.Check 1...&nbsp; If (DOB=AGE, 'GOOD', 'ERROR'). I have different expressions but the result for all of them for each risks would be GOOD or ERROR.</P><P></P><P>I´ve also got different set or risks. E.g. Set A = risks from 1 to 30 (expression will give a GOOD or an ERROR for each risk) </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set B = risks from 50 to 100 ((we can have different checks/expressions than in Set A)</P><P></P><P>What I want to do is in another object (straight table probably) to count the number of GOOD and ERROR by check and set but not by risk (risk shouldn´t be a dimesion I think).</P><P>Eg. Set A. Check 1,&nbsp;&nbsp;&nbsp;&nbsp; 5 GOOD, 25 ERROR</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Check 2,&nbsp;&nbsp;&nbsp;&nbsp; 30 GOOD, 0 ERROR</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set B.Check 1,&nbsp;&nbsp;&nbsp;&nbsp; 49 GOOD, 1 ERROR</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Check 2,&nbsp;&nbsp;&nbsp;&nbsp; 50 GOOD, 0 ERROR</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P></P><P>Thanks in advance.</P><P>Ana</P><P></P><P>El mensaje fue editado por: anabfernandez</P></BODY></HTML> Tue, 26 Jun 2012 19:46:53 GMT 2012-06-26T19:46:53Z Conditional count of values from another object. Please? https://community.qlik.com/t5/QlikView/Conditional-count-of-values-from-another-object-Please/m-p/369253#M575105 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I was wondering if anyone would have any advice about how do the following, please.</P><P></P><P>I´ve got a straigt table where dimension is Number of Risks from 1 to 30 for example and then expressions are if formulas. </P><P>Eg.Check 1...&nbsp; If (DOB=AGE, 'GOOD', 'ERROR'). I have different expressions but the result for all of them for each risks would be GOOD or ERROR.</P><P></P><P>I´ve also got different set or risks. E.g. Set A = risks from 1 to 30 (expression will give a GOOD or an ERROR for each risk) </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set B = risks from 50 to 100 ((we can have different checks/expressions than in Set A)</P><P></P><P>What I want to do is in another object (straight table probably) to count the number of GOOD and ERROR by check and set but not by risk (risk shouldn´t be a dimesion I think).</P><P>Eg. Set A. Check 1,&nbsp;&nbsp;&nbsp;&nbsp; 5 GOOD, 25 ERROR</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Check 2,&nbsp;&nbsp;&nbsp;&nbsp; 30 GOOD, 0 ERROR</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set B.Check 1,&nbsp;&nbsp;&nbsp;&nbsp; 49 GOOD, 1 ERROR</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Check 2,&nbsp;&nbsp;&nbsp;&nbsp; 50 GOOD, 0 ERROR</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P></P><P>Thanks in advance.</P><P>Ana</P><P></P><P>El mensaje fue editado por: anabfernandez</P></BODY></HTML> Tue, 26 Jun 2012 19:46:53 GMT https://community.qlik.com/t5/QlikView/Conditional-count-of-values-from-another-object-Please/m-p/369253#M575105 2012-06-26T19:46:53Z