topic Re: Calculated Dimension with Clear Selection Box in QlikView

Calculated Dimension with Clear Selection Box

krishnacbe — Mon, 13 Aug 2012 12:12:52 GMT

I have used a calculated dimension in a straight table.

Dimension:

=if(ExceptionsTeamIntervention='-1',if(Code='no_suitable_appointment' or Code='contractor_not_found' or Code='appointment_not_found' or Code='manual_deployment_required',ExceptionType))

If I select some value in Exception Type, Current selection box is displayed as below

But In current selection box I need to show only Exception type not Code or ExceptionsTeamIntervention details.

Please anyone help me to fix this.

Thanks in advance.

Regards

Krishna

Re: Calculated Dimension with Clear Selection Box

Mon, 13 Aug 2012 12:15:07 GMT

hi,

shift the expression in the backend.

Re: Calculated Dimension with Clear Selection Box

krishnacbe — Mon, 13 Aug 2012 12:18:11 GMT

Thanks for your fast reply.

I have 3 tabs. In different tabs Code condition varies. So I can't apply the condition in backend. please give some other solution.

Regards

Krishna

Re: Calculated Dimension with Clear Selection Box

chematos — Mon, 13 Aug 2012 20:56:58 GMT

Have you tried to uncheck some option of Current Selection Box? May be there is an option that only shows selected dimensions and nothing else.