Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

skh
Contributor

Using count to create a dimension

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Using count to create a dimension

Hi

Maybe this

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

Expression :  Count( DIstinct  Custcode)

jj

View solution in original post

1 Reply
Not applicable

Using count to create a dimension

Hi

Maybe this

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

Expression :  Count( DIstinct  Custcode)

jj

View solution in original post