topic Chart functions to work as Excel in QlikView

Chart functions to work as Excel

__johan__ — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Chart functions to work as Excel

sunny_talwar — Sat, 17 Sep 2016 23:33:52 GMT

May be this

Re: Chart functions to work as Excel

__johan__ — Sun, 18 Sep 2016 09:36:33 GMT

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

Re: Chart functions to work as Excel

sunny_talwar — Wed, 21 Sep 2016 14:46:45 GMT

Is this what you are looking for?

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)