single master calender for IN and PR

[mshailaja]

the excel sample data is shown below, here i am getting no as IN and PR ,  i created staright table   with dimensions Assigned Group,INS,PRS and Priority and expresion as Count({<TYPE = {'P'}>}NO) Count({<TYPE = {'I'}>}NO) , 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(  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

[m_woolf]

See Rob Wunderlich's tutorial for using common dates:

Search Recipes | Qlikview Cookbook