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

[haupenthals]

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?

 

[lironbaram · Accepted solution]

hi 

yes 

this should be your dimension 

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

and the expression :

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

[haupenthals]

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!