topic Re: Adhoc report in QlikView

Adhoc report

Anonymous — Fri, 07 Nov 2014 05:32:05 GMT

Hi..

I create adhoc report..

Please find following attachment..

In this report when i select the unique menu access selection it displays menu access and unique menu access details but i want to display only selected expression related values ..

Please help me..

Thnanks,

Re: Adhoc report

senpradip007 — Fri, 07 Nov 2014 05:38:55 GMT

Attached file is not opening. Please upload correct application.

Re: Adhoc report

sujeetsingh — Fri, 07 Nov 2014 05:42:39 GMT

failed to open the document.

Re: Adhoc report

Fri, 07 Nov 2014 05:58:09 GMT

Chandini,

It was failed open the document.

are you using following expression:

=substringcount(concat(_metrics,'|'),'unique menu access')

if so 'unique menu access' having the substring 'unique menu access' and 'menu access' also,

so it invoking both 'menu access' and 'unique menu access'.

to avoid this, you can write 'menu access' as 'Menu access' or something like this.

I think you got it now!