Hello All,

[#1]

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

[#2]

No need for Set Analysis.

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

[puttemans]

Would script like this, and leave out the set analysis

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

[#4]

Hi,

Try this.

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

[#5]

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>

[#6]

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

you please suggest.