Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

n1ef5ng1
Contributor

Adhoc Reporting

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

4 Replies
MVP & Luminary
MVP & Luminary

Re: Adhoc Reporting

Hi,

Check this

Adhoc reporting in Qlikview


Regards,

Jagan.

n1ef5ng1
Contributor

Re: Adhoc Reporting

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

MVP & Luminary
MVP & Luminary

Re: Adhoc Reporting

Hi,

Try this expression

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


Regards,

Jagan.

cheburashka
Contributor III

Re: Adhoc Reporting

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