topic Re: adhoc reporting issue in QlikView

adhoc reporting issue

nakuldev — Sat, 16 Nov 2024 01:54:40 GMT

Hi All,

I have developed an Adhoc report in the attached application. The problem is, when I apply few filters there is a mismatch where few other fields are also getting selected as well irrespective of selection. Could someone help me with this?

Thank you in advance.

Thanks

Nakul

Re: adhoc reporting issue

lironbaram — Tue, 19 Nov 2019 09:36:11 GMT

your problem is that you do substringcount so when you select

the dimension Coating Type which is number 17 , you also get the dimensions who have id 1 and 7

in order to work around it ,

change the conditional expression for dimensions for something like this

=SubStringCount('|' & Concat(ServiceDimension_Flag, '|') &'|', '|17|')

that way you'll only activate the dimensions you selected

Re: adhoc reporting issue

nakuldev — Tue, 19 Nov 2019 09:48:15 GMT

Thank you Liron,

I just figured it out.

Thanks

Nakul

Re: adhoc reporting issue

qliksus — Tue, 19 Nov 2019 10:43:35 GMT

Using match( Concat(ServiceDimension_Flag, '|'),7) also gives what you wanted