topic 2 substring count in report builder in QlikView

2 substring count in report builder

T01 — Mon, 25 Oct 2021 15:03:22 GMT

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

Re: 2 substring count in report builder

ManuelRühl — Tue, 26 Oct 2021 06:06:08 GMT

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

Re: 2 substring count in report builder

tresB — Tue, 26 Oct 2021 06:40:06 GMT

May be with a simple and condition like:

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

Re: 2 substring count in report builder

T01 — Tue, 26 Oct 2021 09:37:09 GMT

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.

Re: 2 substring count in report builder

MarcoWedel — Tue, 26 Oct 2021 19:23:53 GMT

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

Re: 2 substring count in report builder

T01 — Thu, 28 Oct 2021 13:45:25 GMT

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

Thank you,