topic Re: Calculation in my Dimension in QlikView

Calculation in my Dimension

Mon, 22 Jul 2013 12:20:13 GMT

Hi there,

We have various product types (4,5,6,7,8,A,B,C,D,E,F,G,H,I and J)

For a specific chart I only want to display products higher than 5 and smaller than E, thus I want my Dimension to show 6,7,8,A,B,C,and D.

I see in my Dimesions tab there is an option right beneath your used dimensions called "Add Calculated Dimesion..."

Can anyone help me with a formula for my specifcation above that I can use.

I typed it as follows:

(Product >'5' and Product<'E')

but it says there is an error in my expession.

Please help.

Thanks!

*R*

Mon, 22 Jul 2013 12:26:18 GMT

if (Product >'5' and Match(Product,'A','B', 'C', 'D' ) AS DIM

Mon, 22 Jul 2013 12:37:16 GMT

Hi,

If product types do not change often, you could do it in a set analysis. See the atached file.

Mon, 22 Jul 2013 13:28:16 GMT

Hi there,

If I use your formula it gives me a error in calculation.

Thanks

kaushiknsolanki — Mon, 22 Jul 2013 13:34:47 GMT

Hi,

Dont give as Dim.

No need to alice it.

So remove the keyword "As Dim"

Regards,

Kaushik Solanki