topic Re: Reg-Condition in QlikView

Reg-Condition

Fri, 29 May 2015 08:20:27 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

we have 5 tabs in this application.for 1-4 tabs id i write this condition.=if(BU='CI' and Year>=2014 and Brand='Essnetiale','Essnetiale inj','Essentiale cap') now its ok .but this should not reflect for 5th tab. for 5th the selections should be done only for year=2015

Can anyone please help me

Re: Reg-Condition

vardhancse — Fri, 29 May 2015 08:27:17 GMT

Use alternate state so that selections will not pass to all the sheet which is having alternate state.

This scenario is nothing but alternate states:

Settings->Document Properties->alternate state(Create)

Sheet 1->Sheet Properties->Alternate state 1

Object 1->Properties->General Tab-.Alternate state 1

Sheet 2->Sheet Properties->Alternate state 2

Object 2->Properties->General Tab-.Alternate state 2

so that selections in sheet 1 will reflect only in object 1 and vice versa

Re: Reg-Condition

mrossoit — Fri, 29 May 2015 08:41:58 GMT

For the first problem, if you want to automate selection changes you have to use triggers as I suppose you did but doing this it's easy to generate anomalies in your qwv's behaviour.

To avoid changes in your 5th tab yu must use alternate states.

I suggest you to upload your file.

Regards,

Re: Reg-Condition

Fri, 29 May 2015 09:07:31 GMT

ok thanks for you reply ,but i cant find the alternate state option in the document properties.

Re: Reg-Condition

awhitfield — Fri, 29 May 2015 09:59:44 GMT

Hi,

it's on the GENERAL tab:

HTH Andy