Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How can I choose the level from wich the data will be extracted when connected to my essbase data source?

Hi, I have the following dimensions:

Market

     -East(+)

          -Market1(+)

          -Market2(+)

     -South(+)

          -Market3(+)

     -Center(+)

          ....

     -West(+)

          ...

Messure

     -Profit

I want to calculate the standart deviation of the profit but only want the consolidated values from East, South, Center, West; I dont want to use every market value.

I don`t want to use the aggr function beacause in the futer I want to do the same analisis with some metrics that comes from a complex calculation from the cube.

Thanks!

Community Browser