Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
__johan__
Contributor II
Contributor II

Chart functions to work as Excel

My knowledge of the map features are limited even though I always work with the set of analysis and trying to optimize as much as I can in the script with flags.

But now I am trying to understand if I can use QlikView in the typical Excel strategy. Attached is an excel where I have 5 columns I try to recreate in QVW file. Everything is in a straight table and expressions must be nested.

- - - - - - -


Mina kunskaper i kartans funktioner är begränsad även om jag alltid arbetar med uppsättningen analys och försöker optimera så mycket som jag kan i skript med flaggor.

Men nu försöker jag förstå om jag kan använda Qlikview i den typiska Excel strategi. Bifogat är en excel där jag har 5 kolumner jag försöker återskapa i QVW filen. Allt är i en rak tabell och uttryck måste kapslas.



Note: Edited by Community Moderator to include English translation as a courtesy. Please use English in main forums.

1 Solution

Accepted Solutions
sunny_talwar

Is this what you are looking for?

Capture.PNG

Expressions

Question 1

Only(TOTAL {<Counter = {0}>}Aggr(Below(RangeAvg(Alt(Above(Sum(Amount)/Sum({$<Counter = {'0'} >} Total Amount)), 0), Sum(Amount)/Sum({$<Counter = {'0'} >} Total Amount)) * vTest1), Counter))

Question 2

Only(TOTAL {<Counter = {5}>}Aggr(Below(RangeAvg(Alt(Above(Sum(Amount)/Sum({$<Counter = {'0'} >} Total Amount)), 0), Sum(Amount)/Sum({$<Counter = {'0'} >} Total Amount)) * vTest1), Counter))

Question 3

=RangeSum(Column(5), -Column(7))/Column(9)

View solution in original post

3 Replies
sunny_talwar

May be this

Capture.PNG

__johan__
Contributor II
Contributor II
Author

Thx Sunny that's exactly the logic I want the chart to display. When I'm trying to implement this in my model it seems like I have issues with Aggr function. I have now updated the dataset to display what I get, do you see what I need to adjust to make this work?


Chart_Help_2.qvw

Chart Result 2


Cheers,

Johan

sunny_talwar

Is this what you are looking for?

Capture.PNG

Expressions

Question 1

Only(TOTAL {<Counter = {0}>}Aggr(Below(RangeAvg(Alt(Above(Sum(Amount)/Sum({$<Counter = {'0'} >} Total Amount)), 0), Sum(Amount)/Sum({$<Counter = {'0'} >} Total Amount)) * vTest1), Counter))

Question 2

Only(TOTAL {<Counter = {5}>}Aggr(Below(RangeAvg(Alt(Above(Sum(Amount)/Sum({$<Counter = {'0'} >} Total Amount)), 0), Sum(Amount)/Sum({$<Counter = {'0'} >} Total Amount)) * vTest1), Counter))

Question 3

=RangeSum(Column(5), -Column(7))/Column(9)

View solution in original post