conditionally hide and show column?

[pgrs4219]

Hi Qlik Community,

I have a requirement like a straight table and a list box called 'Country Selection' ,if i select country 'USA' the column '1','2','3' in the straight table should be hide and if i select 'India ' or 'UK' or 'China' column '4' should hide . am attached the document please find it and and please reply me here .

Thank you

[sunny_talwar]

Check out the attached:

=Aggr(If([Country Selection] = 'usa', Only({<[FieldA Selection] = {4}>}[FieldA Selection]),

If(Match([Country Selection], 'india', 'uk', 'china'), Only({<[FieldA Selection] -= {4}>}[FieldA Selection]), [FieldA Selection])), [FieldA Selection])

[swuehl]

Or maybe with a simple if() statement like this?

=If(

    [FieldA Selection]<=3 and Match([Country Selection], 'india', 'uk', 'china')

      or

    [FieldA Selection]=4 and [Country Selection]='usa'

,[FieldA Selection])