Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Chart functions to work as Excel

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
Highlighted

Re: Chart functions to work as Excel

May be this

Capture.PNG

Highlighted
Contributor II
Contributor II

Re: Chart functions to work as Excel

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

Highlighted

Re: Chart functions to work as Excel

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