topic Re: How to do? in QlikView

How to do?

irmantas — Thu, 19 Nov 2015 11:41:54 GMT

Hello,

I am new here, and have interesting report for me.

Exp.

Client Product QTY

C1 P1 1

C1 P2 1

C1 P3 1

C2 P2 1

C2 P3 1

C3 P1 1

C3 P2 1

I need create report, about Product P1 by Client, but want to know about anther products for the clients hue buy product P1

report must be some like this:

Client Total QTY(P1) Total QTY (P2) Total QTY (P3)

C1 1 1 1

C3 1 1 0

I now need Client C2, because he didn't buy product P1.

How to do it?

Re: How to do?

Mark_Little — Thu, 19 Nov 2015 12:08:26 GMT

Have the client as your dimension.

Then three expressions

SUM({<Product={'P1'}>}QTY)

If(SUM({<Product={'P1'}>}QTY)>0,SUM({<Product={'P2'}>}QTY))

IF(SUM({<Product={'P1'}>}QTY)>0,SUM({<Product={'P3'}>}QTY))

Mark

Re: How to do?

richard_chilvers — Thu, 19 Nov 2015 12:09:19 GMT

I think a good start is to use a Chart, with the Straight Table style.

Use Client and Product as Dimensions and use SUM(QTY) as the expression.

See how it looks. You can play with the formatting and may like to change to a Pivot Table later.

HTH

Re: How to do?

HirisH_V7 — Thu, 19 Nov 2015 12:19:27 GMT

Hi,

Expressions for chart :

Sum({<Product={'P1'}>}QTY)

Sum({<Product={'P2'}>}QTY)

Sum({<Product={'P3'}>}QTY)

PFA....

Hope this Helps!

Cheers,

HirisH

Re: How to do?

irmantas — Thu, 19 Nov 2015 20:20:34 GMT

Thank you for all.

Re: How to do?

oknotsen — Thu, 19 Nov 2015 20:24:05 GMT

If your question is answered, please flagged the Correct Answer.