topic Re: conditionally hide and show column? in QlikView

conditionally hide and show column?

pgrs4219 — Mon, 23 May 2016 20:50:42 GMT

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

Re: conditionally hide and show column?

sunny_talwar — Mon, 23 May 2016 21:06:28 GMT

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])

Re: conditionally hide and show column?

swuehl — Mon, 23 May 2016 21:17:01 GMT

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

=If(

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

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

,[FieldA Selection])