topic Re: Reg-hiding in QlikView

Reg-hiding

Wed, 20 May 2015 09:55:14 GMT

Hi Team ,

we created a straight table and in that we have different filters in the right side of the chart. we have filters like organisation,productyear.

in organisation we have fields like BU,ZONE,RSM.

if we select BU=CI and year =2015 and brand=essentiale then EH should come .

now we have diff products in the product filter.

now the user want if year=2015 and bu=ci an dbrand =Essentiale and den EH should come and the product=essenraile cap should come for eh

and product=Essentaile inj should come if i select CI

CAN ANY ONE HELP ME OUT.

Re: Reg-hiding

sunny_talwar — Wed, 20 May 2015 10:09:49 GMT

Not entirely sure I understand your requirement. Would you be able to share some sample data with the expected out?

Re: Reg-hiding

vardhancse — Wed, 20 May 2015 10:23:03 GMT

Are you saying that based on year and bu selectsion product value should vary.

Re: Reg-hiding

Wed, 20 May 2015 10:30:58 GMT

Yes

Re: Reg-hiding

manojkulkarni — Wed, 20 May 2015 10:33:07 GMT

Not understood your requirement properly, but if you have association between demographics & product then it should work. If possible, share your application.

Re: Reg-hiding

vardhancse — Wed, 20 May 2015 11:15:25 GMT

Yes, if there is association between the tables or related records from the same table then the selections will pass automatically.

Re: Reg-hiding

Wed, 20 May 2015 11:32:49 GMT

can we write an expression if i select BU=CI and year=2015 and brand=Essnetiale den product name should be Essnetiale inj else product name should be Essentiale cap..

can you please let me know the expression should be written for this?

Re: Reg-hiding

manojkulkarni — Wed, 20 May 2015 11:39:16 GMT

=if(BU='CI' and Year=2015 and brand='Essnetiale','Essnetiale inj','Essentiale cap')

Re: Reg-hiding

Wed, 20 May 2015 12:07:41 GMT

Thanks for the mail

can i write this expression in the PRODUCT FILTER

Re: Reg-hiding

manojkulkarni — Wed, 20 May 2015 12:22:21 GMT

Yes, You can write.

Re: Reg-hiding

Wed, 20 May 2015 13:02:45 GMT

thanks manoj

Re: Reg-hiding

manojkulkarni — Wed, 20 May 2015 13:19:58 GMT

Hi Mvrchowdary Rao,

if your problem is resolved with answer, pls mark it & close.