Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Not entirely sure I understand your requirement. Would you be able to share some sample data with the expected out?
Are you saying that based on year and bu selectsion product value should vary.
Not understood your requirement properly, but if you have association between demographics & product then it should work. If possible, share your application.
Yes, if there is association between the tables or related records from the same table then the selections will pass automatically.
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?
=if(BU='CI' and Year=2015 and brand='Essnetiale','Essnetiale inj','Essentiale cap')
Thanks for the mail
can i write this expression in the PRODUCT FILTER
Yes, You can write.