Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Try this expression
=SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Transit_TEU|')
Regards,
Jagan.
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