topic Re: Adhoc Reporting in QlikView

Adhoc Reporting

n1ef5ng1 — Fri, 16 May 2014 01:36:01 GMT

Hi all, I am currently doing an adhoc Interface for QV user to retrieve data on the table.

I have a list of selection fields where when user click, the specific dimension/expression will show on the table.

However, on my expression, I have TEU and Transit_TEU

Using Calculated Condition, I tried using

=SubStringCount(Concat(_Dimension, '|'), 'Transit_TEU')

as well as

=SubStringCount( Concat(DISTINCT _Dimension) ,'Transit_TEU')

It appears Transit_TEU and TEU which is not the output that I am looking for

any advise for this

Re: Adhoc Reporting

jagan — Fri, 16 May 2014 02:11:13 GMT

Hi,

Check this

Adhoc reporting in Qlikview

Regards,

Jagan.

Re: Adhoc Reporting

n1ef5ng1 — Fri, 16 May 2014 02:40:10 GMT

Yeah I have checked through. I am able to do something like this. But problems occur if I have near identical fields such as TEU, Transit_TEU, Box, Transit_Box

Re: Adhoc Reporting

jagan — Fri, 16 May 2014 02:52:37 GMT

Hi,

Try this expression

=SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Transit_TEU|')

Regards,

Jagan.

Re: Adhoc Reporting

cheburashka — Sat, 27 May 2017 19:43:49 GMT

Hello Ben,

I've created a template qvw which contains an improved AdHoc table module (less setup work, more features, pre-designed).

It has all the best ideas about Adhoc reporting which I could find on the QlikCommunity combined in one solution.

A short post about the AdHoc table can be found here. Though I recommend you to take a look at the free explanation video on QlikViewModules.com.

Have fun Qlik'n, Koen