Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
datanibbler
Esteemed Contributor

Dimension problem - is there a solution?

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

1 Reply
sasikanth
Valued Contributor III

Re: Dimension problem - is there a solution?

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.

Community Browser