Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reg-Condition

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

4 Replies
vardhancse
Specialist III
Specialist III

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

mrossoit
Creator II
Creator II

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,

MR

Not applicable
Author

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

awhitfield
Partner - Champion
Partner - Champion

Hi,

it's on the GENERAL tab:

HTH Andy