Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
daniel_sanchezm
Contributor

Pivot Table +Dimensionality () + Sum(Total <> Sales)

Hi everyone,

I have a pivot table with  3 dimensions, and 2 expressions. I need to show total sales by company when Dimensionality()=1, if Dimensionality ()=2 then Sum total sales by SubBrand and if Dimensionality ()=3 then Sum Total sales by store.

I have this expressions:

IF(Dimensionality()=1,

    Sum({$<Discount=,DiscountDescription=,Anio={'$(vMaxAño)'},FlagCatNoExc={1},FlagProdNoExc={1}>} Total TotalSales),

    IF(Dimensionality()=2,

        Sum({$<Discount=,DiscountDescription=,Anio={'$(vMaxAño)'},FlagCatNoExc={1},FlagProdNoExc={1}>} TOTAL <SubBrand,Store> TotalSale),

        Sum({$<Discount=,DiscountDescription=,Anio={'$(vMaxAño)'},FlagCatNoExc={1},FlagProdNoExc={1}>} TOTAL <Store> TotalSale)

    )

   )

It seems to be working only when I expand all the second dimension, if I only expand the secon dimension from one category it doesnt work.  I need  the value doesnt change  if I expand all the second dimension or only one category

Someone can help me?