topic Re: Adhoc Reporting in QlikView

Adhoc Reporting

Thu, 17 Jul 2014 05:11:16 GMT

Hi,

I have been trying to impplement adhoc reporting, i have tried using substringcount function like below to populate the dimension fields into the chart in the enable condidition as -substringcount(concat(Dim_Name,'|'),'CASE'),but in this case when the dimension Case is selected another dimension Case_Type also appears in the chart.So even though the chart needs to be populated only with case dimension ,it gets populated with case and case_type.Please let me know how this could be resolved to get the desired results

Re: Adhoc Reporting

jsingh71 — Thu, 17 Jul 2014 05:19:50 GMT

Hi Anushri,

I also face the same issue some days back. To resolve this issue rename your dimension name in inline load. I solved mine using this only. If still facing the same then load sample app.

Re: Adhoc Reporting

SunilChauhan — Thu, 17 Jul 2014 05:25:34 GMT

see the Report Tab in attached file

Re: Adhoc Reporting

tresB — Thu, 17 Jul 2014 05:26:27 GMT

In such case an extra character would be required to separate out the difference like:

=substringcount(concat(Dim_Name &'@' ,'|'),'CASE@')

Re: Adhoc Reporting

sasikanth — Thu, 17 Jul 2014 05:31:06 GMT

Hi ,

Please find the attachment ,

it will guide you

Re: Adhoc Reporting

SunilChauhan — Thu, 17 Jul 2014 05:33:41 GMT

see the Report Tab in attached file

Re: Adhoc Reporting

cheburashka — Mon, 16 May 2016 22:35:50 GMT

Hi,

For an out of the box (no scripting to create the dimensions) Ad Hoc table solution. Feel free to check out this document.

,KR Koen