Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Iras
Contributor III
Contributor III

Usage of Above and Column functions in Table Chart

Dear all 

I am trying to solve a small issue in one of my tables in Qlik Sense. based on the below table I am trying to generate the comparing average of last two month with current month column in Qlik Sense. 

The logic is to take average of last two month i.e. (300+400)/2 and check whether its greater than the current month i.e. 500 

I tried like this in Qlik : 

if (((above(column(1),0)+above(column(1),0))/2) > above(column(1),3), 'True' ,if(((above(column(1),0)+above(column(1),0))/2) < above(column(1),3),'False','  ' )).

but the logic is showing wrong condition. Could someone help on this issue. 

Reporting Act. Comparing Average of last two month with current month 
01.01.2019300 
01.01.2019400 
01.01.2019500FALSE
01.01.2019600FALSE
01.01.2019700FALSE
01.02.2019400TRUE
01.02.2019500TRUE
01.02.2019600FALSE
01.02.2019700FALSE
01.02.2019800FALSE
01.03.2019500TRUE
01.03.2019600TRUE
01.03.2019700FALSE
01.03.2019800FALSE
01.03.2019900FALSE
Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

Not sure why but seems to work okay for me (in QlikView... should work the same way in Qlik Sense)

Capture.PNG

 

View solution in original post

6 Replies
sunny_talwar

May be something like this

=If(RowNo(TOTAL) > 2, If(RangeAvg(Above(TOTAL Sum(Act), 1, 2)) > Sum(Act), 'TRUE', 'FALSE'))
Iras
Contributor III
Contributor III
Author

Dear Sunny, 

I want to check with one row value below i.e. ((1st month act. value  + 2nd month Act. value )/2)) > (3rd Month Act. value)

 

 

sunny_talwar

Okay, so what is the issue?

Iras
Contributor III
Contributor III
Author

Based on your suggested expression its comparing with the 2nd month Act value. 

How can I specific a specific value  of the column in the expression instead of just sum(act.)

sunny_talwar

Not sure why but seems to work okay for me (in QlikView... should work the same way in Qlik Sense)

Capture.PNG

 

Iras
Contributor III
Contributor III
Author

Sorry I did some mistake. Thanks alot.