topic Re: Hello All, in QlikView

Hello All,

Mon, 16 Mar 2015 13:38:51 GMT

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

Mon, 16 Mar 2015 13:41:02 GMT

No need for Set Analysis.

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

puttemans — Mon, 16 Mar 2015 13:43:22 GMT

Would script like this, and leave out the set analysis

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

Mon, 16 Mar 2015 13:47:21 GMT

Hi,

Try this.

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

Mon, 16 Mar 2015 14:03:54 GMT

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>

Mon, 16 Mar 2015 14:06:08 GMT

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

you please suggest.