topic Dimension in QlikView

Dimension

NavinReddy — Tue, 17 Dec 2013 06:44:32 GMT

Hi All,

Could some one help me this Query

Is it possible to use Expression in Dimension (one interviewer asked this Question)

Thanks in Advance

Niranjan

Sokkorn — Tue, 17 Dec 2013 06:53:06 GMT

Hi Miranjan,

Yes it possible. Example

=If(Field=value,'A','B')

=Aggr(Only( {$<Product = {'AB*','BB*'}>} Seller ),Product)

Regards,

Sokkorn

Anonymous — Tue, 17 Dec 2013 06:55:08 GMT

Yes,

you can use aggr function to expression and it can be used as dimension.

suppose you want to use sum(sales) as dimension and have country as dimension previously.

then new calculated dimension will be,

aggr(sum(sales),country) .

Regards

Nitin

NavinReddy — Tue, 17 Dec 2013 08:03:49 GMT

Thank you to all