Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Doing a Count of Dimension

Hi

Below i have a a sample of my data.

Voucher_NumberDecoder_CodeClaim_DateClaim_Status
SD8 316785V10139142428/08/2013Rejected
SD8 316785V10139142410/09/2013Rejected
SD8 316785V10139142425/09/2013Accepted
SD8 316785V10139142427/09/2013Rejected

I want to create a straight table chart showing the count of claim status.

  •      One column for Count of Rejection and Once column for Count of Accepted with only one dimension which should be the Voucher_Number.

The result im looking for should be as follows.

Voucher_NumberRejectedAccepted
SD8 31678531
1 Solution

Accepted Solutions
Not applicable

Re: Doing a Count of Dimension

Hi

try this,

Dimension Tab: Voucher_Number

Expression Tab:

Rejected:

count({<Claim_Status = {'Rejected'}>}Claim_Status)

Accepted:

count({<Claim_Status = {'Accepted'}>}Claim_Status)

5 Replies
Not applicable

Re: Doing a Count of Dimension

Hi

try this,

Dimension Tab: Voucher_Number

Expression Tab:

Rejected:

count({<Claim_Status = {'Rejected'}>}Claim_Status)

Accepted:

count({<Claim_Status = {'Accepted'}>}Claim_Status)

Not applicable

Re: Doing a Count of Dimension

Hi Alexis

Thank you. It worked.

Kind regards

Nayan

Not applicable

Re: Doing a Count of Dimension

You're welcome^^

Re: Doing a Count of Dimension

HI

Try like this

=Count({<Claim_Status = {'Rejected'}>)Claim_Status)

=Count({<Claim_Status = {'Accepted'}>)Claim_Status)

Not applicable

Re: Doing a Count of Dimension

please close the thread by picking a correct answer

Community Browser