topic Re: Conditional hinding for Possibel Values?? in QlikView

Conditional hinding for Possibel Values??

Wed, 15 Jul 2015 13:27:11 GMT

Hi,

I want to conditionally hide an object.

Please find attached QVW which explains my requirement.

Thanks

Re: Conditional hinding for Possibel Values??

alexandros17 — Wed, 15 Jul 2015 13:37:16 GMT

Like this?

Re: Conditional hinding for Possibel Values??

sunny_talwar — Wed, 15 Jul 2015 13:41:26 GMT

Try this condition:

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

Re: Conditional hinding for Possibel Values??

Wed, 15 Jul 2015 13:55:34 GMT

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??

sunny_talwar — Wed, 15 Jul 2015 14:04:21 GMT

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

Re: Conditional hinding for Possibel Values??

Wed, 15 Jul 2015 14:13:27 GMT

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??

sunny_talwar — Wed, 15 Jul 2015 14:18:28 GMT

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