Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Enable column

Hi All,

I want to enable  Cust and Ctry columns in chart(table) only when user select it.

I have created island table, but not sure how to make it conditional.

The data is below. Please help me with the expression to make the dimensions Cust and Ctry conditional.

Data:
LOAD * INLINE [
Cust, Segment, Ctry, City, Sales
Claire Gute, Consumer, United States, Henderson, 353
Claire Gute, Consumer, United States, Henderson, 261
Darrin Van Huff, Corporate, United States, Los Angeles, 6365
"Sean O'Donnell", Consumer, United States, Fort Lauderdale, 15
"Sean O'Donnell", Consumer, United States, Fort Lauderdale, 1571
Brosina Hoffman, Consumer, United States, Los Angeles, 63461
Brosina Hoffman, Consumer, United States, Los Angeles, 6436
Brosina Hoffman, Consumer, United States, Los Angeles, 671
Brosina Hoffman, Consumer, United States, Los Angeles, 16716
];

Island:
LOAD * INLINE [
DimKey, Dim
Cust,Customer Name
Ctry,Country
];

 

Please help!

Labels (1)
1 Solution

Accepted Solutions
Highlighted

Try this as your dimension enable conditions

=SubStringCount('|' & GetFieldSelections(Dim, '|') & '|', '|Customer Name|')
and
=SubStringCount('|' & GetFieldSelections(Dim, '|') & '|', '|Country|')

View solution in original post

2 Replies
Highlighted

Try this as your dimension enable conditions

=SubStringCount('|' & GetFieldSelections(Dim, '|') & '|', '|Customer Name|')
and
=SubStringCount('|' & GetFieldSelections(Dim, '|') & '|', '|Country|')

View solution in original post

Highlighted
Contributor III
Contributor III

Thank you so much Sunny. Works like a charm.