topic Re: Adhoc Reporting - Measures in QlikView

Adhoc Reporting - Measures

tmumaw — Fri, 04 Nov 2016 12:24:34 GMT

Does anyone know why would both R&M and % R&M come out together when I only select % R&M ? I am working off the _metrics. How can I control only to have R&M % to come up.

MetricsOptions:

LOAD * INLINE [_metricsNo, _metrics

1, LID,

2, Fuel

3, R&M

4, Total Costs

5, Billed Hrs

6, Std Hrs

7, Util %

8, No Units

9, Avg Cost

10, Billed

11, R&M %

12, Fuel %

];

=SubStringCount(Concat(_metrics, '|'),'R&M')

=SubStringCount(Concat(_metrics, '|'), 'R&M %')

Re: Adhoc Reporting - Measures

sunny_talwar — Fri, 04 Nov 2016 12:29:53 GMT

Try it like this for all your measures

=SubStringCount(Concat(DISTINCT '|' & _metrics & '|', ','),'|R&M|')

Re: Adhoc Reporting - Measures

tmumaw — Fri, 04 Nov 2016 12:38:28 GMT

Thanks Sunny T.......Works perfect.