Discussion board where members can get started with QlikView.
I am trying to create a calculated dimension, but i am getting an error, below is the script:
if the value selected in "InspectionTypeRON" is "ECY", then the dimension DeficienceGroupCode has to be used else DeficienceMainGroupCode.
could someone please help out.
No need for Set Analysis.
Would script like this, and leave out the set analysis
=if(InspectionTypeRON = "ECY",count(DeficienceGroupCode),count(DeficienceMainGroupCode)) as ...
=if(InspectionTypeRON ='ECY', DeficienceGroupCode,DeficienceMainGroupCode)
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 <email@example.com>