Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to convert expresssion from Excel to Qlikview

Hello,

I wrote a simple expression in Excel where you can select a month or range of months, sum the values in that range, and divide by the number of months in the range.

The data is loaded into Qlikview as CrossTable(Month, Worked, 7) . The field that needs to be summed is Worked

How can I write this expression in Qlikview so that it changes as I select different months/ranges?

2 Replies
johnw
MVP
MVP

Perhaps one of these?

sum(Worked)/count(distinct Month)

avg(aggr(sum(Worked),Month))

Not applicable
Author

Thanks John!

Actually, I was able to get it working using this:

=num(sum(Worked)/GetSelectedCount(FiscalMonth),0)