topic Re: Make dimension from a variable in QlikView

Make dimension from a variable

phongnnguyen — Mon, 11 Jun 2018 10:14:05 GMT

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

JaMajka1 — Mon, 11 Jun 2018 10:42:37 GMT

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 — Mon, 11 Jun 2018 10:47:46 GMT

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

phongnnguyen — Tue, 12 Jun 2018 03:03:55 GMT

Thanks for your reply,

this is my calculation for variable

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

phongnnguyen — Tue, 12 Jun 2018 03:04:09 GMT

Thanks for your reply,

this is my calculation for variable

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

shanky1907 — Wed, 13 Jun 2018 13:11:10 GMT

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

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