topic Re: Use a Different date in QlikView https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309259#M407159 <HTML><HEAD></HEAD><BODY><P>No not this. When you press Ctrl+T you can see the data model, can you take snapshot of that and paste here pls?</P></BODY></HTML> Fri, 30 Jun 2017 16:08:32 GMT vishsaggi 2017-06-30T16:08:32Z Use a Different date https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309256#M407156 <HTML><HEAD></HEAD><BODY><P>how would i go about having a different date within an expression.</P><P>My table has a created date and closed date. I can count open cases with the created date linked to my calendar but within the same Straight chart I would like to count the closed cases within the same month for Case Count using ClosedDate. </P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168751_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 30 Jun 2017 15:33:17 GMT https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309256#M407156 natisham 2017-06-30T15:33:17Z Re: Use a Different date https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309257#M407157 <HTML><HEAD></HEAD><BODY><P>Can you share a snapshot of your data model? </P></BODY></HTML> Fri, 30 Jun 2017 15:44:48 GMT https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309257#M407157 vishsaggi 2017-06-30T15:44:48Z Re: Use a Different date https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309258#M407158 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168753_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 30 Jun 2017 16:03:32 GMT https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309258#M407158 natisham 2017-06-30T16:03:32Z Re: Use a Different date https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309259#M407159 <HTML><HEAD></HEAD><BODY><P>No not this. When you press Ctrl+T you can see the data model, can you take snapshot of that and paste here pls?</P></BODY></HTML> Fri, 30 Jun 2017 16:08:32 GMT https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309259#M407159 vishsaggi 2017-06-30T16:08:32Z Re: Use a Different date https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309260#M407160 <HTML><HEAD></HEAD><BODY><P>We have alot in this QVD- for the question i use only one table. </P></BODY></HTML> Fri, 30 Jun 2017 16:12:24 GMT https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309260#M407160 natisham 2017-06-30T16:12:24Z Re: Use a Different date https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309261#M407161 <HTML><HEAD></HEAD><BODY><P>You might have to load the calender script again for your closed dates. </P><P></P><P>Read Here.</P><P><A href="https://community.qlik.com/qlik-blogpost/2730">Why You sometimes should Load a Master Table several times</A></P></BODY></HTML> Fri, 30 Jun 2017 16:19:45 GMT https://community.qlik.com/t5/QlikView/Use-a-Different-date/m-p/1309261#M407161 vishsaggi 2017-06-30T16:19:45Z