Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to achieve level metrics in Qlikview?
Thanks in advance
Parthasarathy
Sarathy,
Your expression to get this o/p would be
Sum (Total<Category> sales)
Check the attached appliction.
- Sridhar
Hi Parthasarathy,
Could you please give us more information on what you are looking for.
- Sridhar
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
Sarathy,
Your expression to get this o/p would be
Sum (Total<Category> sales)
Check the attached appliction.
- Sridhar
Remember that in QlikView we most often only make calculations in charts and leave the SQL to simply load the base-data.
Thanks Sridhar