topic Re: Ad-Hoc Report Query in QlikView

Ad-Hoc Report Query

Tue, 05 Mar 2013 11:31:42 GMT

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 — Tue, 05 Mar 2013 11:39:41 GMT

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

Tue, 05 Mar 2013 12:42:27 GMT

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 — Tue, 05 Mar 2013 13:16:21 GMT

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.

Thu, 07 Mar 2013 10:08:23 GMT

Thanks for the solution !