topic Re: Replace missing values in QlikView https://community.qlik.com/t5/QlikView/Replace-missing-values/m-p/903735#M314294 <HTML><HEAD></HEAD><BODY><P>maybe you can compare (add the 2 expressions to the left chart)</P><P>count(distinct FECHA)</P><P><SPAN style="font-size: 13.3333330154419px;">count(distinct TOTAL FECHA)</SPAN></P><P>to know if number of date with transactions of a store is the same as number of dates </P></BODY></HTML> Thu, 25 Jun 2015 18:57:51 GMT maxgro 2015-06-25T18:57:51Z Replace missing values https://community.qlik.com/t5/QlikView/Replace-missing-values/m-p/903734#M314293 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have a problema trying to deal with missing values</P><P></P><P>I have the following tables:</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/90855_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>In the first table I have the Max, Min and Avg of the rigth table, the problem here is in the Min expression because when a data in some date is missing the Min needs to be 0 becase that day the store didn't make transacctions,and not the mínimum value that apeear.</P><P></P><P>Other this is if a can have these two tables only in one</P><P></P><P>Thanks in advance for your help</P></BODY></HTML> Thu, 25 Jun 2015 17:38:55 GMT https://community.qlik.com/t5/QlikView/Replace-missing-values/m-p/903734#M314293 2015-06-25T17:38:55Z Re: Replace missing values https://community.qlik.com/t5/QlikView/Replace-missing-values/m-p/903735#M314294 <HTML><HEAD></HEAD><BODY><P>maybe you can compare (add the 2 expressions to the left chart)</P><P>count(distinct FECHA)</P><P><SPAN style="font-size: 13.3333330154419px;">count(distinct TOTAL FECHA)</SPAN></P><P>to know if number of date with transactions of a store is the same as number of dates </P></BODY></HTML> Thu, 25 Jun 2015 18:57:51 GMT https://community.qlik.com/t5/QlikView/Replace-missing-values/m-p/903735#M314294 maxgro 2015-06-25T18:57:51Z