topic Re: Issue about variable searching in QlikView

Issue about variable searching

Anonymous — Mon, 26 Nov 2018 14:32:46 GMT

When i select a value of the variable "Cluster_F1" (=1, in this case) it takes all the raw (not only "1", but it selects the dimension "POD").
Is there a way to select only a value of the variable "Cluster_F1" instead the dimension "POD"?

Re: Issue about variable searching

dplr-rn — Mon, 26 Nov 2018 17:24:30 GMT

Not completly clear what you mean.
I am assuming you want variable Cluster_F1 to be calculated once globally and not consider the dimension. Is that right?
if so define the variable with = at start like
=If(if(TIPO_..............

Re: Issue about variable searching

Anonymous — Tue, 27 Nov 2018 13:12:25 GMT

Yes, i don't want to consider the dimension when i select the variable ClusterF1, which is already defined as variable as follows:
SET v_Cluster1=IF($(v_Tot_cons_perd)<5000,1,
IF($(v_Tot_cons_perd)<20000,2,
IF($(v_Tot_cons_perd)<500000,3,4
)));

Re: Issue about variable searching

dplr-rn — Tue, 27 Nov 2018 14:13:32 GMT

I meant define it like below with the = which means it will be calculated only once and not change when you add it into tables/charts

Re: Issue about variable searching

Anonymous — Tue, 27 Nov 2018 15:02:32 GMT

Ok, i tried but it worked like before in the selection (it selects only the dimension and not the entire cluster of observations with the same value of Cluster1), moreover it returns the same value for the observations of the variable Cluster1.