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: 
manu1512
Creator
Creator

adhoc reports

Can any one help me in understanding the concept of ad hoc reporting ?

Please help me in understanding this following expression of conditional enabling?

=SubStringCount('|' & Concat(distinct Measure, '|') & '|', '|Sum|')

Regards

Manu

4 Replies
Anonymous
Not applicable

Hi Manu,

  By selecting Sum in the filter you are showing corresponding expression on the fly.

Here SubStringCount  returns the no of occurrences for the specified  SubString.

-Jai

manu1512
Creator
Creator
Author

Can you pls elaborate more?

sunny_talwar

The concept is basically empowering your users to select what dimensions and/or expressions they want to look at. There is some pre-work that developers do (like deciding what are dimensions (from a list of 100 fields, they may want to give 10 as dimension and 7 as expressions). Now the user can add/remove stuff without having to reach out to the developer.

SubStringCount('|' & Concat(distinct Measure, '|') & '|', '|Sum|')

Measure is most likely an island table where the user gets an option to select if he want to Sum, Avg, Min, Max of the expression...

So, based on the selection in Measure... a concatenated list is prepared and checked if Sum is one of those values or not... if it, then expression will be true, else it will be false.

Does that make sense?

manu1512
Creator
Creator
Author

You are genius