topic Re: Reg-condition display in QlikView

Reg-condition display

Thu, 28 May 2015 05:29:45 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 if i select BU=CI and year =2015 and brand =Essentiale and product=Essentiale inj. This should be changed from BU=EH and product=Essentaile cap

i have wriiten condition lie this.

=if(BU='CI' and Year>=2014 and Brand='Essnetiale','Essnetiale inj','Essentiale cap') now its ok But the problem is if i give this condition iam getting EH and i aslo getting another bu like pc.

This PC SHOULD NOT COME ONLY EH SHOULD BE APPEAR

CAN ANY ONE HELP ME OUT.

Re: Reg-condition display

sujeetsingh — Thu, 28 May 2015 05:47:11 GMT

You can use a select on trigger for this field and use an action "Select in Field"

Re: Reg-condition display

Siva_Sankar — Thu, 28 May 2015 05:51:36 GMT

Can you share the application?

Re: Reg-condition display

Thu, 28 May 2015 05:59:03 GMT

=if(BU='CI' and Year>=2014 and Brand='Essnetiale','Essnetiale inj','Essentiale cap') for this condition iam getting EH.But PC IS ALSO COMING. I WANT TO HIDE PC.

CAN U PLEASE SUGGEST IN WRITING ANY CONDITION HERE ITSELF