Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
yone,
I ask the Qlikview expert to help me about a simple problematic I have.
I have this data and i want to have the sum of the data per article but i just want to show the article.
Facture Number, Article, customer_id, amount
F1,Pen, 10,10€
F2,Pen,10,10€
F3,Pen,12,12€
F4,Pencil,10,13€
F4,Pencil,10,13€
F5,Pencil,11,14€
result :
Pen,20€
Pen,12€
Pencil, 26€
Pencil, 14€
I cannot see how to do this 😞 .
thank you for your help.
Regards,
@Touix if you are in qliksense no need to hide dimension:
you can add table and
in dimension:
Article
in an other dimension use :
=aggr( sum(amount),customer_id,Article)
output:
you can use =sum(aggr( sum(amount),customer_id,Article))
as measure
and Article, customer_id as dimension
and hide customer_id dimension
Hello taoufik,
Can you tell me how to hide a dimension please ?
@Touix if you are in qliksense no need to hide dimension:
you can add table and
in dimension:
Article
in an other dimension use :
=aggr( sum(amount),customer_id,Article)
output:
Thank you very much Taoufik.
You helped me a lot.