topic Set analysis in QlikView https://community.qlik.com/t5/QlikView/Set-analysis/m-p/428840#M490827 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Iam making an app to show the number of deleted orders.</P><P>The graph only show the dates where there are deleted orders&gt;0.</P><P></P><P>I have two tables: Facts and Time</P><P></P><P></P><P>Expressions: sum(status), sum({&lt;status={1}&gt;}amount)</P><P></P><P>ie. the number of deleted orders and the value of them per selected time interval.</P><P></P><P></P><P>I want the graph to show 0 if there are no deleted orders that day, and then 0 in value.</P><P></P><P></P><P>Can you help me?</P><P>I guess i need to put in year, month and Day in the expressions?</P><P></P><P></P><P>/Julia</P></BODY></HTML> Fri, 21 Sep 2012 12:02:35 GMT 2012-09-21T12:02:35Z Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/428840#M490827 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Iam making an app to show the number of deleted orders.</P><P>The graph only show the dates where there are deleted orders&gt;0.</P><P></P><P>I have two tables: Facts and Time</P><P></P><P></P><P>Expressions: sum(status), sum({&lt;status={1}&gt;}amount)</P><P></P><P>ie. the number of deleted orders and the value of them per selected time interval.</P><P></P><P></P><P>I want the graph to show 0 if there are no deleted orders that day, and then 0 in value.</P><P></P><P></P><P>Can you help me?</P><P>I guess i need to put in year, month and Day in the expressions?</P><P></P><P></P><P>/Julia</P></BODY></HTML> Fri, 21 Sep 2012 12:02:35 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/428840#M490827 2012-09-21T12:02:35Z