topic Re: Help me in writing caliculated dimension? in QlikView https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886508#M1012273 <HTML><HEAD></HEAD><BODY><P>use this,</P><P>=If(WildMatch(Dept_Id,'*A*') ,'Accounts','Finance')</P></BODY></HTML> Wed, 22 Apr 2015 16:50:17 GMT buzzy996 2015-04-22T16:50:17Z Help me in writing caliculated dimension? https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886503#M1012268 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi All,</SPAN></P><P></P><P><SPAN style="color: #000000;">I have below dimension</SPAN></P><P></P><P><SPAN style="color: #000000;"><STRONG>Dept_Id</STRONG></SPAN></P><P><SPAN style="color: #000000;">1234A.2344</SPAN></P><P><SPAN style="color: #000000;">2345A.2567</SPAN></P><P><SPAN style="color: #000000;">1567A.1456</SPAN></P><P><SPAN style="color: #000000;">2758A.1234</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #000000;">1234F.2344</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #000000;">2345F.2567</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #000000;">1567F.1456</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #000000;">2758F.1234</SPAN></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #000000;">Now i need to write the caliculated dimension based on the department id values in barchart.</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #000000;">If the deptid value contains A then it belongs to the ACCOUNTS department.</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #000000;">If the deptid value contains F then it belongs to the FINANCE department.</SPAN></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #000000;">I need to display barchart with two bars (one is Accounts and other is Finance).</SPAN></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #993300;"><STRONG>Note:</STRONG> I have already one expression which will show the total of values for particular department. So i need to divide department into two categories based on dimension.</SPAN></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #000000;">So please help in writing caliculated dimension.</SPAN></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #000000;">Thanks,</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #000000;">Durga</SPAN></P></BODY></HTML> Wed, 22 Apr 2015 16:29:57 GMT https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886503#M1012268 durgabhavani 2015-04-22T16:29:57Z Re: Help me in writing caliculated dimension? https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886504#M1012269 <HTML><HEAD></HEAD><BODY><P>You can use the Pick WildMatch combo in your script and then use that new field in your chart..</P><P><SPAN style="font-size: 13.3333330154419px;"><STRONG>Pick(WildMatch</STRONG>(<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">Dept_Id,'*F*,'*<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">A*')</SPAN>,'Finance','Accounting') as DeptGroup,</STRONG></SPAN></P></BODY></HTML> Wed, 22 Apr 2015 16:42:46 GMT https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886504#M1012269 b_garside 2015-04-22T16:42:46Z Re: Help me in writing caliculated dimension? https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886505#M1012270 <HTML><HEAD></HEAD><BODY><P>Or use this as your calculated dimension:</P><P></P><P><STRONG>If(KeepChar(Dept_Id, 'A,F') = 'A', 'Accounting', 'Finance')</STRONG></P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Wed, 22 Apr 2015 16:46:43 GMT https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886505#M1012270 sunny_talwar 2015-04-22T16:46:43Z Re: Help me in writing caliculated dimension? https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886506#M1012271 <HTML><HEAD></HEAD><BODY><P>You can use either suggestion in chart or in script. Both will work.</P></BODY></HTML> Wed, 22 Apr 2015 16:48:17 GMT https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886506#M1012271 b_garside 2015-04-22T16:48:17Z Re: Help me in writing caliculated dimension? https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886507#M1012272 <HTML><HEAD></HEAD><BODY><P>PFA a sample application for you to review</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Wed, 22 Apr 2015 16:49:24 GMT https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886507#M1012272 sunny_talwar 2015-04-22T16:49:24Z Re: Help me in writing caliculated dimension? https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886508#M1012273 <HTML><HEAD></HEAD><BODY><P>use this,</P><P>=If(WildMatch(Dept_Id,'*A*') ,'Accounts','Finance')</P></BODY></HTML> Wed, 22 Apr 2015 16:50:17 GMT https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886508#M1012273 buzzy996 2015-04-22T16:50:17Z Re: Help me in writing caliculated dimension? https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886509#M1012274 <HTML><HEAD></HEAD><BODY><P>@Brain: It is simply working! Thanks much!</P><P></P><P>@Sunindia: it is also working! Thanks</P><P>But I am unable to open .qvw file as i have no access.</P><P></P><P>@Shiva: Useful</P><P></P><P>Thanks everyone!</P></BODY></HTML> Wed, 22 Apr 2015 17:10:32 GMT https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886509#M1012274 durgabhavani 2015-04-22T17:10:32Z Re: Help me in writing caliculated dimension? https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886510#M1012275 <HTML><HEAD></HEAD><BODY><P>Glad it worked. </P></BODY></HTML> Wed, 22 Apr 2015 17:24:34 GMT https://community.qlik.com/t5/QlikView/Help-me-in-writing-caliculated-dimension/m-p/886510#M1012275 b_garside 2015-04-22T17:24:34Z