adhoc reporting issue

[nakuldev]

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

[lironbaram · Accepted solution]

hi 

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 

[nakuldev]

Thank you Liron,

I just figured it out. 

Thanks

Nakul

[qliksus]

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