Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
n1ef5ng1
Creator
Creator

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
jagan
Luminary Alumni
Luminary Alumni

Hi,

Check this

Adhoc reporting in Qlikview


Regards,

Jagan.

n1ef5ng1
Creator
Creator
Author

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
Luminary Alumni
Luminary Alumni

Hi,

Try this expression

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


Regards,

Jagan.

cheburashka
Creator III
Creator III

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