Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: Hello All,

No need for Set Analysis.

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

Highlighted
puttemans
Valued Contributor

Re: Hello All,

Would script like this, and leave out the set analysis

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

Not applicable

Re: Hello All,

Hi,

Try this.

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

Not applicable

Re: Hello All,

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

Re: Hello All,

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

you please suggest.