topic If statements and aggrigates in QlikView https://community.qlik.com/t5/QlikView/If-statements-and-aggrigates/m-p/491374#M183613 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with customers, then data set type.</P><P></P><P>Each month we receive data from these customers of various data set types. I want to have a gauge to show that we've received last month's data ok for each customer, and each data set type that we've received before.</P><P></P><P>I have this as the expression in the pivot table:</P><P></P><P>if(Max({&lt;Indirects.Year={$(=Year(AddMonths(Today(), -1)))}&gt;} Indirects.Month) = Num(Month(AddMonths(Today(), -1))) And&nbsp;&nbsp; Max(Indirects.Year) = Num(Year(AddMonths(Today(), -1))),1,0)</P><P></P><P>This works ok when drilling down to the detail, but if I collapse the data set type dimension then I get "1" if any of the data sets are ok, rather than if all are ok.</P><P></P><P>What I want is a "0" for the customer row if any data set type row has a "0".</P><P></P><P>How can I do this?</P></BODY></HTML> Tue, 26 Nov 2013 07:55:28 GMT Anonymous 2013-11-26T07:55:28Z If statements and aggrigates https://community.qlik.com/t5/QlikView/If-statements-and-aggrigates/m-p/491374#M183613 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with customers, then data set type.</P><P></P><P>Each month we receive data from these customers of various data set types. I want to have a gauge to show that we've received last month's data ok for each customer, and each data set type that we've received before.</P><P></P><P>I have this as the expression in the pivot table:</P><P></P><P>if(Max({&lt;Indirects.Year={$(=Year(AddMonths(Today(), -1)))}&gt;} Indirects.Month) = Num(Month(AddMonths(Today(), -1))) And&nbsp;&nbsp; Max(Indirects.Year) = Num(Year(AddMonths(Today(), -1))),1,0)</P><P></P><P>This works ok when drilling down to the detail, but if I collapse the data set type dimension then I get "1" if any of the data sets are ok, rather than if all are ok.</P><P></P><P>What I want is a "0" for the customer row if any data set type row has a "0".</P><P></P><P>How can I do this?</P></BODY></HTML> Tue, 26 Nov 2013 07:55:28 GMT https://community.qlik.com/t5/QlikView/If-statements-and-aggrigates/m-p/491374#M183613 Anonymous 2013-11-26T07:55:28Z