Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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?

Community Browser