Adhoc Reporting

[n1ef5ng1]

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

[jagan]

Hi,

Check this

Adhoc reporting in Qlikview

Regards,

Jagan.

[n1ef5ng1]

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

[jagan]

Hi,

Try this expression

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

Regards,

Jagan.

[cheburashka]

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