topic Re: Can I make the Expression a Dimension? in QlikView

Can I make the Expression a Dimension?

Fri, 25 Nov 2016 11:12:28 GMT

Hello,

In the attached document I have a simple table with three columns:

Company

Bucket

Revenue

The column Bucket is an expression and I would like for it to be a dimension as I want to group the data by Bucket rather than Company to produce a few bar charts.

I've no idea if this is possible

In a different tool I would make the chart be based on the table (and not the data in the underlying document) if that makes sense... but I don't thing that QV allows this... and I am not sure I can create a virtual table for the chart either.

Any ideas or suggestions?

Thanks,

Re: Can I make the Expression a Dimension?

Gysbert_Wassenaar — Fri, 25 Nov 2016 11:31:37 GMT

You can create a calculated dimension:

= aggr( Floor(

RangeSum(Above(Sum([Revenue]),0,RowNo()))

vBucketAmount

) + 1

,Company)

Re: Can I make the Expression a Dimension?

Fri, 25 Nov 2016 12:07:07 GMT

Thanks for the answer... it is almost perfect except when the data is a combination of a number of rows... I cannot seem to get around this now.

I have updated the document and there are two tables one which has the correct order and one which is has the updated dimension.

Do you have any ideas on how to get over this last hurdle?

Thanks for any suggestions and thanks for the answer above.