Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)
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!