Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

haupenthals
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?

 2019-06-30 07_58_46-QlikView x64 - [Z__01 Logistikcontrolling (Haupenthals)_01 Regelmäßige Auswertun.pngUnbenannt.PNG

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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

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)

2 Replies
Highlighted
Partner
Partner

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

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
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!