Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

naykesh4ev
naykesh4ev
Contributor
‎02-28-2017 07:01 AM

Above Function not working when there is more than 1 dimension

Hi

I am struggling with "Above" function in a chart when I have more than one dimension.  The above function works perfectly, when I have only one dimension.

Please can you assist.

Attached herewith is a the sample data and Qlikview Model.

Thanking you in advance.

Kind regards

Nayan

Data_Calls.xlsx
Data_Calls.qvw
234 Views
0 Likes
Reply
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP
‎02-28-2017 07:15 AM

Re: Above Function not working when there is more than 1 dimension

Not sure what the expected output is, but try with Above(TOTAL ...)

Above(TOTAL Sum(Calls))


Capture.PNG

Data_Calls.qvw
51 Views
0 Likes
Reply
2 Replies
sunny_talwar
MVP
MVP
‎02-28-2017 07:15 AM

Re: Above Function not working when there is more than 1 dimension

Not sure what the expected output is, but try with Above(TOTAL ...)

Above(TOTAL Sum(Calls))


Capture.PNG

Data_Calls.qvw
52 Views
0 Likes
Reply
naykesh4ev
naykesh4ev
Contributor
‎02-28-2017 07:54 AM

Re: Above Function not working when there is more than 1 dimension

Thank you Sunny

51 Views
0 Likes
Reply
Community Browser