Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Include Or Exclude Dimensions

Hi All,

     We have scenario to include or exclude specific dimension value. I have attached the QVW file along with the excel datasource..

There are 3 dimensions in the attached QVW file. Milk Bottle (Dimension-DIM2) is available under Baby Product (Dimension-DIM1) and also inside  Self Care (DIM2).

There is a button which will tell me whether to inlude Milk Bottle into the Baby Product or Self Care?. On this button click i need to inlucde Milk Bottle to Baby Product and exclude from Self Care?

Can you help me finding a solutions for this ie dynmically including or excluding dimension values?



1 Reply
Not applicable

Can you explain more the user experiece you are seeking?

If the user selets Dim 1 = Baby Product, then by association the selection of Dim2 = Milk Bottle works as expected.

Likewise if the user drills down using your "Test Table" and the drill down group.

If the user instead starts with clear selections, and selects Dim2 = Milk Bottle, then they can either select a Dim 1 value, or a Dim3 value, but the association takes care of itself.  You could add a button that selects one or the other in Dim 1 if you want (where Action is 'Select in Field', Field is 'Dim 1', and value is Baby Product, for example).  But if you already have a list box with Dim 1 available, would it not be easier to just use that (and more clear to the user)?

Perhaps I misunderstand you?