topic Re: single master calender for IN and PR in QlikView https://community.qlik.com/t5/QlikView/single-master-calender-for-IN-and-PR/m-p/1126027#M894226 <HTML><HEAD></HEAD><BODY><P>See Rob Wunderlich's tutorial for using common dates:</P><P><A href="http://qlikviewcookbook.com/recipes/download-category/scripting/" title="http://qlikviewcookbook.com/recipes/download-category/scripting/">Search Recipes | Qlikview Cookbook</A></P></BODY></HTML> Thu, 04 Aug 2016 13:30:35 GMT m_woolf 2016-08-04T13:30:35Z single master calender for IN and PR https://community.qlik.com/t5/QlikView/single-master-calender-for-IN-and-PR/m-p/1126026#M894225 <HTML><HEAD></HEAD><BODY><P>the excel sample data is shown below, here i am getting no as IN and PR ,&nbsp; i created staright table&nbsp;&nbsp; with dimensions Assigned Group,INS,PRS and Priority and expresion as <SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">TYPE</SPAN><SPAN style="font-size: 8pt;"> = {'P'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">NO</SPAN><SPAN style="font-size: 8pt;">) <SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">TYPE</SPAN><SPAN style="font-size: 8pt;"> = {'I'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">NO</SPAN><SPAN style="font-size: 8pt;">) </SPAN> </SPAN>, i tried with two master calenders seperately for IN and PR based on Opendate and i am getting correct data, and if i am creating single calender (for IN and PR)based on Opendate, i am getting wrong data(&nbsp; for IN i am getting correct data , but for PR i am getting wrong data) the above excel sheet is only sample, actually the data is in crores , anyone can please help creating single master calender for IN and PR</P><P><IMG __jive_id="133539" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133539_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/single-master-calender-for-IN-and-PR/m-p/1126026#M894225 mshailaja 2020-11-25T16:16:04Z Re: single master calender for IN and PR https://community.qlik.com/t5/QlikView/single-master-calender-for-IN-and-PR/m-p/1126027#M894226 <HTML><HEAD></HEAD><BODY><P>See Rob Wunderlich's tutorial for using common dates:</P><P><A href="http://qlikviewcookbook.com/recipes/download-category/scripting/" title="http://qlikviewcookbook.com/recipes/download-category/scripting/">Search Recipes | Qlikview Cookbook</A></P></BODY></HTML> Thu, 04 Aug 2016 13:30:35 GMT https://community.qlik.com/t5/QlikView/single-master-calender-for-IN-and-PR/m-p/1126027#M894226 m_woolf 2016-08-04T13:30:35Z