Adhoc report - Dimensions adding

[priyarane]

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.

[ecolomer]

See this example

[priyarane]

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.

[qlikviewwizard]

Hi Priya,

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

[cheburashka]

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