Using count to create a dimension

Sunil_Kenth — Mon, 12 Sep 2011 18:49:32 GMT

Hi,

Is it possible to use the 'create calculated dimension' to create a dimension based on my data? I would like to create a dimension which counts the number of invoices in the selection, i would then expect the x axis to display numbers i.e 1 - 10, and plotted on the y axis the number of customers that have that number of invoices.

The table looks like this:

InvNo. , CustCode, Amt

1, Guar01, 2000.00

2, Field22, 196.48

3, Promo01, 201.55

4, Promo01, 196.45

Thanks,

Sunil

Using count to create a dimension

Mon, 12 Sep 2011 19:04:07 GMT

Maybe this

DImension : Aggr ( Count( Distinct InvNo) , Custcode)

Expression : Count( DIstinct Custcode)

topic Using count to create a dimension in QlikView

Using count to create a dimension

Using count to create a dimension