topic derived Dimension object in QlikView

derived Dimension object

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to show Calculated Dimension values as Sales A,

Sales B ,

Sales C ,

Sales D as show shown in legend.

How to show?

Thanks in advance.

Re: derived Dimension object

sunny_talwar — Mon, 24 Oct 2016 05:47:34 GMT

Is this what you are looking to get?

I unchecked the 'Show Legend' on the presentation tab to get the names on the axis

Re: derived Dimension object

jagan — Mon, 24 Oct 2016 06:30:30 GMT

HI,

Why can't you do crosstable() and use it as dimension.

CrossTable(SalesType, Sales)

LOAD Sales_Type,

Sales_A,

Sales_B,

Sales_C,

Sales_D

FROM

DATA.xls

(biff, embedded labels, table is Sheet1$);

Now use

Dimension: SalesType

Expression: Count({<Sales={'>0'}>}Sales_Type)

This way you don't need to write multiple expressions, in future if you get Sales_E for example, this will deal automatically, no need to change your app again.

Regards,

Jagan.