Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
T01
Contributor
Contributor

2 substring count in report builder

Hello all, 

i need help: how can i put a substringcount with dimension, but with filter too? 

i want to apear the dimension "norm" only if i have selected '1st layer' filter

T01_0-1635174132439.png

 

5 Replies
mruehl
Partner - Specialist
Partner - Specialist

You want to show an entry of a dimension based conditionally on another dimension?

tresesco
MVP
MVP

May be with a simple and condition like:

Substringcount(Concat(#Dimensions, '|'), 'norm') AND Substringcount(Concat(#Dimensions, '|'), '1st layer')

 

T01
Contributor
Contributor
Author

I would like to show an entry of a conditional dimension based on a single selected filter. more precisely: when I selected x layer *example: customer care* from "1st layer", only then to have the "norm" dimension available.

MarcoWedel

what means "... only then to have the "norm" dimension available"?

You want to see the "norm" entry in the "#Dimensions" ListBox only if this condition is met?

thanks for clarifying
Marco

T01
Contributor
Contributor
Author

yes, that's what i want. sorry for misunderstanding

 

Thank you, 

T