Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

I know this is going to be an easy one, but.....

Hi  - I have created a pivot, which gives me a count of cases by agent.

How do I then calculate those cases by a £ value.

For example - J. Bloggs shows 5 cases in the pivot table.  I want to multiply those cases by £10 each, so that the pivot would show the name (J. Bloggs), the case count (5) and the amount £50.

I'm pretty sure this won't be hard to do, but guess if you don't know how to do it, you don't know how to do it!

Thanks for your help.

Si

1 Solution

Accepted Solutions
Not applicable

I know this is going to be an easy one, but.....

Yes, just add another expression that has just the formula for count.

First Expression=Count(cases)*10

Second Expression=Count(Cases)

4 Replies
Not applicable

I know this is going to be an easy one, but.....

I am guessing you have a simple count statement as the expression. if yes, leave that expression there count(cases) * 10

Then change the expression type to money.

Not applicable

I know this is going to be an easy one, but.....

Thanks, can I get the count to show alongside the £value?

Not applicable

I know this is going to be an easy one, but.....

Yes, just add another expression that has just the formula for count.

First Expression=Count(cases)*10

Second Expression=Count(Cases)

Not applicable

I know this is going to be an easy one, but.....

Thank You, sorted!

Community Browser