Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Reg-hiding

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.

11 Replies

Re: Reg-hiding

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

vardhancse
Valued Contributor II

Re: Reg-hiding

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

Not applicable

Re: Reg-hiding

Yes

manojkulkarni
Valued Contributor II

Re: Reg-hiding

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



vardhancse
Valued Contributor II

Re: Reg-hiding

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

Not applicable

Re: Reg-hiding

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?

manojkulkarni
Valued Contributor II

Re: Reg-hiding

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

Not applicable

Re: Reg-hiding

Thanks for the mail

can i write this expression in the PRODUCT FILTER

manojkulkarni
Valued Contributor II

Re: Reg-hiding

Yes, You can write.

Community Browser