Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

in your sample data it seams to be no CBU when status=MKT

so it seams to be normal if the rest of your data is like this.

you would like to do the exlcution in script while importing data or when visualizing it?

QlikView Qlik Sense consultant
filippo_cardoso
Contributor III
Contributor III
Author

Hi,

I'd like to exclude only in MKT while visualizing it.

Thanks for the fast response

kfoudhaily
Creator III
Creator III

in set analysis, if you are calculating let say the sum for "Jan"

then you should do

sum({$<Status-={'MKT'}>}Jan)

please note the "-=" to exclude


or even more:

sum({$<Status-={'MKT'}>}Jan) + sum({$<Status-={'MKT'}>}Fev)



do you want to make it independent from selections in CBU too?

QlikView Qlik Sense consultant
filippo_cardoso
Contributor III
Contributor III
Author

Yes.

I want to show the same amout when, for example, I choose: only CBU1 or CBU 2 or both.

Thanks.

kfoudhaily
Creator III
Creator III

try this:

sum({$<CBU=,Status-={'MKT'}>}Jan) + sum({$<CBU=,Status-={'MKT'}>}Fev)


you can also check this link for more info:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/SetAnalys...



Best Regards,

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

QlikView Qlik Sense consultant
filippo_cardoso
Contributor III
Contributor III
Author

My mistake. I think its not clear.

I want to show MKT amount's but exluding any filter from CBU.

thanks again

venelin_rs
Contributor III
Contributor III

Hi Filippo,

If I understand correctly you want to ignore CBU, so use the following expression:

sum({$<CBU= >}Jan)


If it is not working that, you can fill in all blank values with "mapping" function. Later you can play with this new value in your formula as "Set Analysis"

filippo_cardoso
Contributor III
Contributor III
Author

Exactly.

But I want to exclude only in MKT filter. I want to show at the same time in a bar chart: mkt excluding cbu and fcst including cbu.

thanks

venelin_rs
Contributor III
Contributor III

Why you don't try with 2 different expressions:

     sum({$<Status={'MKT'} , CBU= >}Jan) and sum({$<Status={'fcst '} , CBU={1,2} >}Jan)


Something like that.