# New to QlikView

Discussion board where members can get started with QlikView.

New Contributor III

## Sequential numbers (1-13) as dimension in straight table chart

I have a straight table with deliverynote as Dimension and number of parcels as Expression. I export it in Excel, then I build a Chart to show the percentage of deliveries with one parcel, two parcels, three parcels etc...

Is there a way to get this kind of Chart also in QlikView?

Labels (1)
• ### Calculated dimension

1 Solution

Accepted Solutions
Highlighted
Partner

## Re: Sequential numbers (1-13) as dimension in straight table chart

hi

yes

num(subfield(class (aggr(sum(no_of_parceles),deliverynote),1)'<',1))

and the expression :

count (distinct deliverynote)/count(total distinct deliverynote)

2 Replies
Highlighted
Partner

## Re: Sequential numbers (1-13) as dimension in straight table chart

hi

yes

num(subfield(class (aggr(sum(no_of_parceles),deliverynote),1)'<',1))

and the expression :

count (distinct deliverynote)/count(total distinct deliverynote)

New Contributor III

## Re: Sequential numbers (1-13) as dimension in straight table chart

I have just added one comma to your suggested calculated Dimension :

num(subfield(class (aggr(sum(no_of_parceles),deliverynote),1), '<',1))

THANK YOU VERY MUCH!