Conditional hinding for Possibel Values??

[#1]

Hi,

I want to conditionally hide an object.

Please find attached QVW which explains my  requirement.

Thanks

[alexandros17]

Like this?

[sunny_talwar · Accepted solution]

Try this condition:

=Only(Category) = 'AAA' and SubStringCount(Concat(DISTINCT ID, '|'), 'AAA')=Count({1}If(WildMatch(ID, '*AAA'), ID))

[#4]

Hi,

Thanks for reply. I gave example of AAA to explain my requirement, but i have more than 10K values in my data . Is there any solution where .

For example in the attached QVW , when user hit BBB in Category the conditional text box should appear as BBB is one of the possible field in ID associated to BBB in Category.

[sunny_talwar]

Created two variables and used them in tour conditional statement:

=SubStringCount(Concat(DISTINCT ID, '|'), '$(vVar1)')=Count({1}If(WildMatch(ID, '$(vVar)'), ID))

See if this helps.

Best,

Sunny

[#6]

Hi,

thanks you, in your example when we select AAA and BBB, but it seems to be not working when we select CCC.

[sunny_talwar]

Not sure if you data model was correct, but if you change to this model, it seems to work:

test:

Load * Inline

[CatID, Category

001,AAA

002,AAA

100,BBB

200,BBB

200,CCC

201,CCC

];

test2:

load CatID,

  Category,

    CatID & '-' &  Category  as ID

Resident test;

DROP Table test;

We need to get a more representative sample of your actual data to make it to work.

HTH

Best,

Sunny