Dimension problem - is there a solution?

datanibbler — Wed, 22 Feb 2017 12:14:52 GMT

Hi,

I have an app where I link two tables - delivery_plans and packing_plans - to determine how much packing_material will be needed to fulfill what is in the delivery_plans for the coming weeks.

There are several dimensions to both tables.

So far, so good. When I have all necessary dimensions active, all is well.

What I'd like to implement for the user, however, is the possibility to activate or deactivate the dimensions (except one, of course, there has to be some dimension).

<=> Then I run into problems because in certain circumstances, figures cannot be aggregated correctly, so I have the dash in my chart in that case and the figures are incorrect.

Is there a possibility to check if, somewhere in the chart acc. to the currently active selections, there is the dash (there are different values)? I'd like to implement an alert.

It should be possible to find a solution - there has to be a way to correctly aggregate everything - but there's no time and it's not that important.

Thanks a lot!

Best regards,

DataNibbler

Re: Dimension problem - is there a solution?

sasikanth — Wed, 22 Feb 2017 12:32:15 GMT

HI,

If there are less number of dimensions for user selection then you can go for Flags in script

some thing like below

Load * INLINE

DIM,Dim1flag,dim2flag,dim3flag

Dim1,1,0,0

Dim2,0,1,0

Dim3,0,0,1

];

Use Dimension--> Enable Conditional-->Dim1flag=1 or Dim2flag=1 for Dim2

Exp: sum(Aggr(sum(Sales),Dim1))*Dim1flag+ sum(Aggr(sum(Sales),Dim2))*Dim2flag+

sum(Aggr(sum(Sales),Dim3))*Dim3flag

Always one dimension should be selected.

topic Re: Dimension problem - is there a solution? in QlikView

Dimension problem - is there a solution?

Re: Dimension problem - is there a solution?