Repeated Value in Dimension

Fri, 22 Mar 2013 15:38:03 GMT

Hi All,

I could do with some help with my dimensions...

I have a table showing total sales for departments in one of our stores, but I need to be able to show a total of the entire fashion floor for example, as well as a total of only some of the sections within that floor.

My dimension looks like this at the moment:

if ( AND DWH_ITEM_SUB_GROUP > 0

AND (DWH_ITEM_SUB_GROUP=62

OR DWH_ITEM_SUB_GROUP=60

OR DWH_ITEM_SUB_GROUP=45

OR DWH_ITEM_SUB_GROUP=43)

,'OWN BOUGHT FASHIONS',

if ( AND DWH_ITEM_SUB_GROUP > 0

AND (DWH_ITEM_PRODUCT_GROUP_NO=528

OR DWH_ITEM_PRODUCT_GROUP_NO=529

OR DWH_ITEM_SUB_GROUP=62

OR DWH_ITEM_SUB_GROUP=60

OR DWH_ITEM_SUB_GROUP=51

OR DWH_ITEM_SUB_GROUP=45

OR DWH_ITEM_SUB_GROUP=43)

,'TOTAL FASHION FLOOR'))

However, at the moment the results in the first row (own bought fashions) show the total of SUB-GROUPs 62,60,45,and 43 in 1 row, while the next row (total fashion floor)shows only the total of SUB-GROUP 43 and PRODUCT_GROUPs 528 and 529.

Is there any way that I can get 'Total fashion Floor' to include the sub_groups which are repeated?

The table contains other similar rows which all work fine, so I can't do a simple total at the bottom (unless there is a way to show a subtotal on just these 2 lines?)

Thanks,

Matthew

Re: Repeated Value in Dimension

Fri, 22 Mar 2013 16:40:47 GMT

You can try to create a flag when you load the table , or a flag in a load resident table in script .

topic Repeated Value in Dimension in QlikView

Repeated Value in Dimension

Re: Repeated Value in Dimension