Get Possible Value for a certain field from Table

phaneendra_kunc — Thu, 20 Oct 2011 00:34:45 GMT

I have a requirement, where i have to show and hide the columns based on the possible field value.

Example:

in straight table i have 3 columns which they needs to be shown on hidden based on Indicator column.

so if i pick BrandA through BranC, then the possible values are Y,N,Y

we have setuped the columns for each brand in a straight table, based on the field selections.

so in those 3 columns i have to hide the 2nd column as BrandB is N.

Any help is very helpuful

Thanks,

phani

Thu, 20 Oct 2011 02:10:28 GMT

Can you add the below expression:

sum({<Indicator={'Y'}>} 1)

and hide the expression in presentation tab.

topic Get Possible Value for a certain field from Table in QlikView