I think what phaneendra.kunche suggested is the best solution, you will have better control over the dimensions. Infact without calculated dimensions and using multiple charts you can do this using Dimension limits. Just show and hide the charts based on the Selected value in View_by. Calculated dimensions will have performance issues sometimes.
Re: Calculated dimension(Dynamic) based on selections
Sorry i jump in here. Hope you guy are okay. as i try to get in touch with Jagan
I am Paul , I believe you know me , because you have help me settle many QV issue in the past.
Most of the time i though you are working for Qlik , Suddenly when i read a blog post , and mentioned the top contributor in forum , and you are one of them , and in your profile , it mentioned you work in singapore and since you are living and working in singapore , and most of the time i spend my time at indonesia , and happen that this week i am not travel , and will be stay at singapore , so i like to invite you for evening chat and buy you some dinner.
Hope that you can let me know when are you free ? and let me know where you like me to meet you ? i waiting for your reply soon. kindly send me a SMS to my HP 93261804