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

Hello All,

I am trying to create a calculated dimension, but i am getting an error, below is the script:

=if({$<InspectionTypeRON ={'ECY'}>},DeficienceGroupCode,DeficienceMainGroupCode)

Dimensions used:

InspectionTypeRON

DeficienceGroupCode

if the value selected in "InspectionTypeRON" is "ECY", then the dimension DeficienceGroupCode has to be used else DeficienceMainGroupCode.

could someone please help out.

DeficienceMainGroupCode

5 Replies
Not applicable
Author

No need for Set Analysis.

If(InspectionTypeRON="ECY", DeficienceGroupCode,DeficienceMainGroupCode)

puttemans
Specialist
Specialist

Would script like this, and leave out the set analysis

=if(InspectionTypeRON = "ECY",count(DeficienceGroupCode),count(DeficienceMainGroupCode)) as ...

Not applicable
Author

Hi,

Try this.

=if(InspectionTypeRON ='ECY', DeficienceGroupCode,DeficienceMainGroupCode)

Not applicable
Author

Thanks... but still the dimension does not appear in my pivot table. could

you please suggest.

On Mon, Mar 16, 2015 at 7:17 PM, krishnama naidu <qcwebmaster@qlikview.com>

Not applicable
Author

Thanks... but still the dimension does not appear in my pivot table. could

you please suggest.