Enable column

surajdhall — Sat, 16 Nov 2024 04:02:03 GMT

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!

Re: Enable column

sunny_talwar — Wed, 27 Mar 2019 12:06:28 GMT

Try this as your dimension enable conditions

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

Re: Enable column

surajdhall — Wed, 27 Mar 2019 12:20:27 GMT

Thank you so much Sunny. Works like a charm.

topic Re: Enable column in QlikView

Enable column

Re: Enable column

Re: Enable column