topic Re: Ignoring Same fields again and again in QlikView

Ignoring Same fields again and again

Anonymous — Thu, 25 Jun 2015 11:50:29 GMT

Hi All,

We have two volume fields like vol1 and vol2, and have number of dimensions.

Our requirement is to calculate sum vol1 and vol2, agnoring dimensions 1 to 5.

So we have written the expression like -

sum({<dim1=,dim2=,dim3=,dim4=,dim5=>}vol1) +sum({<dim1=,dim2=,dim3=,dim4=,dim5=>}vol2)

We have all other expressions which is using {<dim1=,dim2=,dim3=,dim4=,dim5=>} for number of times.

Is there is any way we can suppress the expression length and improve performance.

Please assist.

Regards,

Re: Ignoring Same fields again and again

swuehl — Thu, 25 Jun 2015 11:55:17 GMT

You can define and use a variable for your set expression.

Re: Ignoring Same fields again and again

Thu, 25 Jun 2015 11:57:19 GMT

Create a variable say vdimignore with definition as {<dim1=,dim2=,dim3=,dim4=,dim5=>}. Then use the variable in the expression as $(vdimignore). It reduces the length of your expressions and increases reusability. If there are any changes in the set expression, only variable expression has to be updated.

Re: Ignoring Same fields again and again

settu_periasamy — Thu, 25 Jun 2015 11:58:42 GMT

Hi,

create the variable, then you can use it inside of sum

like vDim :

dim1=,dim2=,dim3=,dim4=,dim5=

Then, sum ({<$(vDim)>}vol1)

Re: Ignoring Same fields again and again

Anonymous — Fri, 26 Jun 2015 06:54:16 GMT

Is there is any way, where I can get it from Script.

Re: Ignoring Same fields again and again

settu_periasamy — Fri, 26 Jun 2015 06:59:45 GMT

In the script you can set this variable like

SET vDim=dim1=,dim2=,dim3=,dim4=,dim5=;

Re: Ignoring Same fields again and again

Anonymous — Fri, 26 Jun 2015 07:02:18 GMT

will this improve performance if we compare it with using variable.

Re: Ignoring Same fields again and again

settu_periasamy — Fri, 26 Jun 2015 07:24:12 GMT

I think so. Just assigned the text to the variable. Also, You can assign the calculation expression to the variable