Synthetic Dimension

sudhakar_b — Sun, 30 Jun 2013 14:52:28 GMT

I have data like the following

Property - which is nothing but a grouping of Brands

Ex. Fridge as a property will have brands like Samsung, LG etc,

TV as a property will have brands like Sony, Samsung etc.

Assuming sales are stored at the Brand Level and there is a table with Property, Brand mapping

Now i would like to show a chart with an expression as sum(sales), the dimension values should be Fridge, Samsung, LG, TV, Sony, Samsung etc.

Basically a synthetic dimension of Property and Brand.

Again, there could be 100's of brands and properties, so would need a fexible solution

Any pointers/help is appreciated.

Thanks

topic Synthetic Dimension in QlikView