topic Re: adhoc reports in QlikView

adhoc reports

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: adhoc reports

Anonymous — Fri, 23 Mar 2018 07:31:40 GMT

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

Re: adhoc reports

manu1512 — Fri, 23 Mar 2018 07:35:21 GMT

Can you pls elaborate more?

Re: adhoc reports

sunny_talwar — Fri, 23 Mar 2018 11:43:45 GMT

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?

Re: adhoc reports

manu1512 — Fri, 23 Mar 2018 11:49:25 GMT

You are genius