Ad-Hoc Report Query

[#1]

Hi,

I am creating a Customized Report.

It is very much similar to the 'Reports' Tab in the Demo App of Qlikview(as Attached),difference being the Number of Expressions/ Columns used.

The Number of Expressions/Columns in my app is greater than 9 while in the Demo App of Qlikview it is  4.

The Challange faced is with the condition cheching which is like:

=SubStringCount(Concat(_metricsNo, '|'), 1)

Apparently when value in the '_metricsNo' is 12, the Fields getting Displayed are for  _metricsNo 1, 2, 12 which should be only be for _metricsNo 12.

Have attached the relevent files.

Please suggest a workaround.

Thanks !

[Gysbert_Wassenaar]

You could use the names instead of numbers for your metrics. That's one way to solve the problem.

[#3]

Appreciate the reply Gysbert.

I tried using names instead, but the name conflict remains.

Attaching a demo app, here when I select 'Equipment_Status'...the 'Status' field is getting auto selected.

I have many such combinations of words as fields in my table..

Hence the problem persists.

Any alternative to the condition checking instead of

' =SubStringCount(Concat(_metricsNo, '|'), 1) '

Thanks!

[Gysbert_Wassenaar · Accepted solution]

Ok, try adding extra | characters then:

=SubStringCount('|'&Concat(Col_Num, '|')&'|' ,'|1|')

or if you use the Col_Name field:

=SubStringCount('|'&Concat(Col_Name, '|')&'|' ,'|Status|')

And don't use the | character in the column names.

[#5]

Thanks for the solution !