Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnacbe
Partner - Specialist III
Partner - Specialist III

Calculated Dimension with Clear Selection Box

Hi

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

CurrentSelection.JPG

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

3 Replies
Not applicable

hi,

shift the expression in the backend.

krishnacbe
Partner - Specialist III
Partner - Specialist III
Author

Hi

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

chematos
Specialist II
Specialist II

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.