Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
phongnnguyen
Contributor II
Contributor II

Make dimension from a variable

Dear guys,

I have a problem with dimension. I calculated $v_branch. And I want to make this to become a dimension. How I can do that

Thanks for your consider

Labels (1)
5 Replies
JaMajka1
Partner Ambassador
Partner Ambassador

Hi Phong,

what is the content of your variable? Is it a string consists of more values separated by a specific character or anything else?

BR,

Maria

shanky1907
Creator II
Creator II

Can you please write down what is the calculation happeining for v_branch?

phongnnguyen
Contributor II
Contributor II
Author

Thanks for your reply,

this is my calculation for variable

v_branch=aggr(${max(TDate)}BranchName,AccID))

phongnnguyen
Contributor II
Contributor II
Author

Thanks for your reply,

this is my calculation for variable

v_branch=aggr(${max(TDate)}BranchName,AccID))

shanky1907
Creator II
Creator II

Can you check with the below expression if it works fine for you:

=Only({<BranchName={'$(v_branch)'}>}BranchName)