Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Repeated Value in Dimension

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

1 Reply
Not applicable

Re: Repeated Value in Dimension

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

Community Browser