Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Distribution - Calculated Dimension

Hi All,

I am trying to create a distribution graph that shows the number (distinct) of clients with a certain Average $/Kg, eg number of farmers between 2.0 and 2.5, farmers between 2.5 and 3.0 etc. I have attached a spreadsheet with some dummy data. I am not sure about the scripting for the calculated dimension. Average $/Kg is Value($)/Kgs. Please also note that each client may have more than one transaction.

Any assistance appreciated.

Herbiec

1 Solution

Accepted Solutions
MVP
MVP

Re: Distribution - Calculated Dimension

maybe in the attachment

2 Replies
MVP
MVP

Re: Distribution - Calculated Dimension

maybe in the attachment

Not applicable

Re: Distribution - Calculated Dimension

Perfect Massimo,

Thank you very much, exactly what I needed.

Much appreciated

H

Community Browser