Dynamic data buckets aggregation issue

Fri, 27 Sep 2013 06:13:20 GMT

Hi everyone ,

I am creating buckets of revenue dimension as follows

If([Net Revenue]/1000<0,-15,

If([Net Revenue]/1000=0,15,

If([Net Revenue]/1000>255,255,

Ceil(([Net Revenue]/1000),15))))

Problem is in axis tab I have to set max value because I want to keep two adjacent charts have same y-axis.

So when I found max value by aggregating expression by above calculated dimension then according to help I cant do that because aggr can only have single field not an expression or calculated dimension. So any solution if I can use anything similar to calculate max value of chart?

One more thing I cant move this calculated dimension to the load script as user can adjust Net Revenue by a factor so every record will have dynamic adjusted net revenue.

Any help is highly appreciated.

Regards:

Mubbasher Khaliq

Re: Dynamic data buckets aggregation issue

marcus_sommer — Fri, 27 Sep 2013 10:39:48 GMT

Just as idea - you could use a variable for your max y-axis in all charts. Also you could put variables in the calculated dimension for indiviually adjustments by the users.

You could als see to class() function - perhaps it si an alternatively approach for the calculated dimension.

- Marcus

topic Dynamic data buckets aggregation issue in QlikView

Dynamic data buckets aggregation issue

Re: Dynamic data buckets aggregation issue