Discussion board where members can get started with QlikView.
i have a pivot table with this hierarchy
category product total
i wish a column which shows the number of products for each category. can you redirect me to a thread if my question is a duplicate?
Go to Solution.
B1-2 seems to me a subset of B1-1 when I look at the table where you link Z3ARGOS_BLOC to PLANIF.
So the numbers seems ok to me.
You probably need to look into using the total qualifier with a field list (check the Help for this), like:
Hope this helps,
Try this, it gives number of product in a category
Hope it helps
i have tried using the count(total<category> product) but its not good:
here is a sample of what i am trying to achieve:
can you help me?
In my expression, category and product must be field names, not e.g. column labels.
Your above table shows what you want to achieve or what you see in real life using my expression?
If that's what you want to achieve, I think you should maybe use mayilvahanan's expression count(distinct product) and add a partial sum in presentation tab for your first dimension.
If this does not help you, could you upload a small sample?
my expression is count(distinct product) (label>>"Total")
but when i go to presentation tab> i cannot add partial sum to "Total"
why is that?
Add the partial sum to your first dimension.
please guys can you check the file i just uploaded? my internet is a bit slow..that's why i took so much time..
its not working when i pu the partial sum on the first dimension
when i expand BLOC1 i have B1-1 and B1-2 and i have total 264 for each.
but this is false because when i collapse BLOC1 i have 264.
Sorry, my mistake, you need to add the partial sum for the last dimension, Product.