topic Level Metrics in Qlikview in QlikView

Level Metrics in Qlikview

Fri, 12 Aug 2011 05:45:05 GMT

How to achieve level metrics in Qlikview?

Thanks in advance

Parthasarathy

sridhar240784 — Fri, 12 Aug 2011 07:07:47 GMT

Hi Parthasarathy,

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

- Sridhar

Fri, 12 Aug 2011 09:30:56 GMT

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 — Fri, 12 Aug 2011 09:40:16 GMT

Sarathy,

Your expression to get this o/p would be

Sum (Total<Category> sales)

Check the attached appliction.

- Sridhar

klausskalts — Fri, 12 Aug 2011 10:14:56 GMT

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

Fri, 12 Aug 2011 10:59:27 GMT

Thanks Sridhar