Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Conditional hinding for Possibel Values??

Hi,

I want to conditionally hide an object.

Please find attached QVW which explains my  requirement.

Thanks

1 Solution

Accepted Solutions

Re: Conditional hinding for Possibel Values??

Try this condition:

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

View solution in original post

6 Replies

Re: Conditional hinding for Possibel Values??

Like this?

Re: Conditional hinding for Possibel Values??

Try this condition:

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

View solution in original post

Not applicable

Re: Conditional hinding for Possibel Values??

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.

Re: Conditional hinding for Possibel Values??

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

Not applicable

Re: Conditional hinding for Possibel Values??

Hi,

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

Re: Conditional hinding for Possibel Values??

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