Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
filippo_cardoso
Contributor III
Contributor III

Excluding a Dimension

Dear all,

In qlikview, I have a data base in that way, as below:

      

StatusYearProduct CategoryCBUFamilyJanFev
FCSTCYCars1L2934
FCSTCYCars1M6764
FCSTCYCars1H1422
FCSTCYCars2L99
FCSTCYCars2M79
FCSTCYCars2H57
MKTCYCars L11
MKTCYCars M00
MKTCYCars H1121

I have a problem: I'd like to show all MKT volumes when I choose any CBU (1 and/or 2). But MKT appears as a "blank" CBU dimension

What should I do?

Regards

10 Replies
kfoudhaily
Creator III
Creator III

so this should be ok:

sum({$<CBU= >}Jan)

whatever value from CBU calculate sum

QlikView Qlik Sense consultant