topic Adhoc report - Dimensions adding in QlikView

Adhoc report - Dimensions adding

priyarane — Sat, 05 Sep 2015 04:06:42 GMT

Hi Community,

I am working on Adhoc report need to add 150 dimensions and Enable condition for that to table so its taking much time.

For Ex:

Dim1, Dim2.......Dim150 and for them enable condition like SubStringCount(GetFieldSelections(%Dimensions), 'WRH Name') > 0

Is there any way we can add all together or any macro for that.

Re: Adhoc report - Dimensions adding

ecolomer — Sat, 05 Sep 2015 06:53:58 GMT

See this example

Re: Adhoc report - Dimensions adding

priyarane — Sat, 05 Sep 2015 14:06:31 GMT

Hi Enrique,

Thanks for the reply..

But I wanted to add dimensions all together at time because, I have 200 dimensions so its difficult add enable condition and dimension manually.

Re: Adhoc report - Dimensions adding

qlikviewwizard — Sat, 05 Sep 2015 15:58:23 GMT

Hi Priya,

Really it is surprise to see that using 200 dimensions in a report.

Re: Adhoc report - Dimensions adding

cheburashka — Sat, 27 May 2017 19:28:15 GMT

Hello Guys,

Are you looking for an AdHoc table that doesn't require the timely setup?

I've created an AdHoc table which is independent of the dimensions you have. It means that in the first dimension of the table you can place any of your 200 dimensions. You just have to list your dimensions, comments, expressions in an excel and the adhoc table is ready.

A short post about the AdHoc table can be found here.

Have fun Qlik'n, Koen

QlikViewModules.com