Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Frequence tabulation

I need you help for this.

I have a transaction table with4 columns

  1. - Id client
  2. - date of transaction
  3. - product purchase
  4. - Amount of product

From these datas , I would want to create a new summary table by Number of transaction

- Number of transaction (1 , 2 , 3 , ...) ; count of clients ; total amount

For example, I want to know, how many single client (who bougth one time), ...

I would want to know if I can build my table without using the script (with simple table) or i need to aggregate datas on the script ?

Thanks for your help

Jean-Jacques

Tags (2)
1 Reply
prieper
Honored Contributor II

Frequence tabulation

For a unique transaction-number you should hardcode this in the script. Other calculations can be done in simple table/graphs, just with your required aggregation as Expression and required dimension. In the first approach think that this should do - you may then go lateron into more sophisticated formulas.

HTH
Peter

Community Browser