topic Re: Set analysis with dimension variable in QlikView

Set analysis with dimension variable

Anonymous — Thu, 07 Jan 2016 14:05:52 GMT

Hi all,

I'm editing a text object with this expression:

=count(distinct {<v_bo_delta_create={'<=$(=v_bo_marg_inf_create)'}, elem_tech_code={'BO'}, elem_type_code={'UNI'}>} elem1_sk)

where

v_bo_delta_create=num(round(Today()-(MAX(elem_updatedt))))

v_bo_marg_inf_create is an input box. Current value is 100.

This expression doesn't work.

I also tried with " "

=count(distinct {<v_bo_delta_create={"<=$(=v_bo_marg_inf_create)"}, elem_tech_code={'BO'}, elem_type_code={'UNI'}>} elem1_sk)

but doesn't work.

I think problem are variables.

I looked at this thread Set Analysis - Dimension as variable but doesn't help me very much.

Any ideas?

Thanks

Re: Set analysis with dimension variable

sunny_talwar — Thu, 07 Jan 2016 16:13:26 GMT

What about one of these:

=Count(DISTINCT {<v_bo_delta_create = {"$(='<=' & $(=v_bo_marg_inf_create))"}, elem_tech_code={'BO'}, elem_type_code={'UNI'}>} elem1_sk)

=Count(DISTINCT {<v_bo_delta_create = {"$(='<=' & $(v_bo_marg_inf_create))"}, elem_tech_code={'BO'}, elem_type_code={'UNI'}>} elem1_sk)

Re: Set analysis with dimension variable

Anonymous — Fri, 08 Jan 2016 09:13:06 GMT

Those expressions return same value even if v_bo_delta_create is > then v_bo_marg_inf_create.

I try to explain:

v_bo_marg_inf_create = 100

v_bo_delta_create = 70

both expressions returns a value (429).

But if i set

v_bo_marg_inf_create = 60

v_bo_delta_create = 70

i suppose that correct returned value is 0 because the clause v_bo_delta_create <= v_bo_marg_inf_create is not verified, instead the returned value is always 429.

Where I am wrong?

Thank you