topic Excel/Qlik in QlikView https://community.qlik.com/t5/QlikView/Excel-Qlik/m-p/855355#M299825 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P></P><P></P><P>2.Interface_Issue_Count</P><P>=CALCULATE(DISTINCTCOUNT(Data[measure_id]); Data[interface_status] &lt;&gt; "OK"; NOT(ISBLANK(Data[interface_status])))</P><P>=sum(Measure.Nbr);??????;????</P><P></P><P></P><P>4.IPSLA-Issue-Count</P><P></P><P></P><P>CALCULATE(DISTINCTCOUNT(Data[measure_id]); Data[ipsla_ok] = FALSE(); NOT(ISBLANK(Data[ipsla_ok])))</P><P></P><P></P><P>je veux traduire c'est deux formules sur qlikview svpppp</P></BODY></HTML> Fri, 17 Apr 2015 08:38:33 GMT 2015-04-17T08:38:33Z Excel/Qlik https://community.qlik.com/t5/QlikView/Excel-Qlik/m-p/855355#M299825 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P></P><P></P><P>2.Interface_Issue_Count</P><P>=CALCULATE(DISTINCTCOUNT(Data[measure_id]); Data[interface_status] &lt;&gt; "OK"; NOT(ISBLANK(Data[interface_status])))</P><P>=sum(Measure.Nbr);??????;????</P><P></P><P></P><P>4.IPSLA-Issue-Count</P><P></P><P></P><P>CALCULATE(DISTINCTCOUNT(Data[measure_id]); Data[ipsla_ok] = FALSE(); NOT(ISBLANK(Data[ipsla_ok])))</P><P></P><P></P><P>je veux traduire c'est deux formules sur qlikview svpppp</P></BODY></HTML> Fri, 17 Apr 2015 08:38:33 GMT https://community.qlik.com/t5/QlikView/Excel-Qlik/m-p/855355#M299825 2015-04-17T08:38:33Z