Level Metrics in Qlikview

[#1]

How to achieve level metrics in Qlikview?

Thanks in advance

Parthasarathy

[sridhar240784]

Hi Parthasarathy,

Could you please give us more information on what you are looking for.

- Sridhar

[#3]

Sridhar,

my report requirement  goes like  this

Category     sub-category     sales     sales(category level)

X                    A                     2                 3  

X                    B                     1                 3

Y                    A                    3                  8    

Y                    B                    4                  8

Y                    C                    1                  8

I want to achieve the Sales(category level) using Qlikview functions,

my sql script is just a select from a table which contains category, subcategory and sales columns, I should not modify the SQL script.

Is it achievable using Qlikview functionality?

- Sarathy

[sridhar240784 · Accepted solution]

Sarathy,

Your expression to get this o/p would be

Sum (Total<Category> sales)

Check the attached appliction.

- Sridhar

[klausskalts]

Remember that in QlikView we most often only make calculations in charts and leave the SQL to simply load the base-data.

[#6]

Thanks Sridhar