Calculated Dimension

krishnacbe — Mon, 06 Aug 2012 07:05:17 GMT

I have used a caluclated Dimension in graphs. If i select particular dimension value in chart, Current selection shows all the dimensions used in calculation. For example

if( IsNull(CloseDate)='-1',
if(Code='amber_sla_breach' or
Code='red_sla_breach' or
Code='emergency_sla_breached' or
Code='awaiting_parts_sla_breach' or
Code='emergency_sla_breach' or
Code='onsite_red_sla_breach' or
Code='onsite_amber_sla_breach'
, BreachType

))

In Current selection box

Fields Values

BreachType SLA Breach - On Site Red

Code emergency_sla_breached, onsite_amber_sla_breach, onsite_red_sla_breach, red_sla_breach

I need to display only BreachType.

Thanks in advance.

topic Calculated Dimension in QlikView

Calculated Dimension