Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Averages

Hi,

Quick question: I'm able to average simple variables, however, the avg. function doesn't seem to work when I'm using set analysis. In my business, we have several types of sales, all housed under the variable 'sales' and differentiated by another variable called 'transaction type'. I've been using set analysis to differentiate amongst the different types of sales and it works well. However, I'm unable to calculate averages, standard deviations, etc and I'm pretty sure it has to do with the set analysis.

Has anyone else found this problem? If so, is there a way around it? I've attached an example to help explain my issue better.

Thanks for the help!

Matt

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Averages

Try this

avg({<[Transaction Type ID]={"10"}>} [Sales])


2 Replies
Not applicable

Averages

Try this

avg({<[Transaction Type ID]={"10"}>} [Sales])


Not applicable

Averages

Works perfectly - Thanks Nick!

Community Browser