topic Expressions based on different dimensions. in QlikView https://community.qlik.com/t5/QlikView/Expressions-based-on-different-dimensions/m-p/785263#M1052620 <HTML><HEAD></HEAD><BODY><P>I've been trying to search how to do this, but I can't find anything.</P><P></P><P>I have two date fields: created date and closed date. I also have two expressions in count of all orders, and count of orders closed if status=closed.</P><P></P><P>Essentially I want a grouped bar chart that counts orders created during a week, or closed during that week. However, adding the two date fields as dimensions doesn't work, and I'm not sure how to achieve this. </P><P></P><P>Any ideas?</P></BODY></HTML> Thu, 06 Nov 2014 23:03:01 GMT 2014-11-06T23:03:01Z Expressions based on different dimensions. https://community.qlik.com/t5/QlikView/Expressions-based-on-different-dimensions/m-p/785263#M1052620 <HTML><HEAD></HEAD><BODY><P>I've been trying to search how to do this, but I can't find anything.</P><P></P><P>I have two date fields: created date and closed date. I also have two expressions in count of all orders, and count of orders closed if status=closed.</P><P></P><P>Essentially I want a grouped bar chart that counts orders created during a week, or closed during that week. However, adding the two date fields as dimensions doesn't work, and I'm not sure how to achieve this. </P><P></P><P>Any ideas?</P></BODY></HTML> Thu, 06 Nov 2014 23:03:01 GMT https://community.qlik.com/t5/QlikView/Expressions-based-on-different-dimensions/m-p/785263#M1052620 2014-11-06T23:03:01Z Re: Expressions based on different dimensions. https://community.qlik.com/t5/QlikView/Expressions-based-on-different-dimensions/m-p/785264#M1052621 <HTML><HEAD></HEAD><BODY><P>Anyone have any info on this? Or is my question confusing? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 10 Nov 2014 19:12:49 GMT https://community.qlik.com/t5/QlikView/Expressions-based-on-different-dimensions/m-p/785264#M1052621 2014-11-10T19:12:49Z Re: Re: Expressions based on different dimensions. https://community.qlik.com/t5/QlikView/Expressions-based-on-different-dimensions/m-p/785265#M1052622 <HTML><HEAD></HEAD><BODY><P>PFA, hope to understand</P></BODY></HTML> Mon, 10 Nov 2014 19:36:04 GMT https://community.qlik.com/t5/QlikView/Expressions-based-on-different-dimensions/m-p/785265#M1052622 maxgro 2014-11-10T19:36:04Z Re: Expressions based on different dimensions. https://community.qlik.com/t5/QlikView/Expressions-based-on-different-dimensions/m-p/785266#M1052623 <HTML><HEAD></HEAD><BODY><P>This is excellent!!! Thank you soo much! Conceptually I had an idea how to do it, but didn't know how to execute it. This is perfect, thanks for all the help!</P></BODY></HTML> Mon, 10 Nov 2014 23:31:26 GMT https://community.qlik.com/t5/QlikView/Expressions-based-on-different-dimensions/m-p/785266#M1052623 2014-11-10T23:31:26Z