topic Re: How To Use Alternative State In Conditional Enablement of Dimensions ??? in QlikView

How To Use Alternative State In Conditional Enablement of Dimensions ???

Sun, 09 Sep 2012 20:58:18 GMT

Dear All,

I am trying to use the QV Ver. 11 new feature "Alternate State" in "Conditional Enablement Of Dimension" and I am stucked in this.

I am trying to wright, right expression for it but every time geting syntex error. What is the right syntex I dont know.

any one please help me in this.

I am attaching my example.

Thanks In Advance

Regards

- IndianQvLover

Mon, 10 Sep 2012 06:56:28 GMT

I had Try

1. =if( { [ Group 1 ]::caGrp1='City'},1,0) -------- Error In Syntex

2. =if( { [ Group 1 ]::caGrp1={ 'City' } },1,0) -------- Error In Syntex

and some more

Please Guide me.

Regards

IndianQvLover

Mon, 10 Sep 2012 09:47:46 GMT

after reading some community post and some R&D I found that a Set Analysis will be used in this situation instead of IF statment

=count( { $ < caGrp1={'City'} > } Flag )