Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have below dimension
Dept_Id
1234A.2344
2345A.2567
1567A.1456
2758A.1234
1234F.2344
2345F.2567
1567F.1456
2758F.1234
Now i need to write the caliculated dimension based on the department id values in barchart.
If the deptid value contains A then it belongs to the ACCOUNTS department.
If the deptid value contains F then it belongs to the FINANCE department.
I need to display barchart with two bars (one is Accounts and other is Finance).
Note: 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.
So please help in writing caliculated dimension.
Thanks,
Durga
You can use the Pick WildMatch combo in your script and then use that new field in your chart..
Pick(WildMatch(Dept_Id,'*F*,'*A*'),'Finance','Accounting') as DeptGroup,
You can use the Pick WildMatch combo in your script and then use that new field in your chart..
Pick(WildMatch(Dept_Id,'*F*,'*A*'),'Finance','Accounting') as DeptGroup,
Or use this as your calculated dimension:
If(KeepChar(Dept_Id, 'A,F') = 'A', 'Accounting', 'Finance')
HTH
Best,
Sunny
You can use either suggestion in chart or in script. Both will work.
PFA a sample application for you to review
Best,
Sunny
use this,
=If(WildMatch(Dept_Id,'*A*') ,'Accounts','Finance')
@Brain: It is simply working! Thanks much!
@Sunindia: it is also working! Thanks
But I am unable to open .qvw file as i have no access.
@Shiva: Useful
Thanks everyone!
Glad it worked.