topic Re: My chart 2016 bar display when i select compute eXP in QlikView

My chart 2016 bar display when i select compute eXP

paulyeo11 — Tue, 29 Mar 2016 13:17:19 GMT

Hi All

I have a CHART 1 , when i click on display in Org or S$ currency , the CHART able to display summary total SALES amount FOR ONE COMPANY OR ALL COMPANY.

The minute when user select the compute by eXP , the overall total amount disappear FOR 2016.

I try to modify the expression using Chart 2 by add Aggr as below :-

Sum(Aggr(Sum({<$(ColumnDim601)={$(ColumnDim601)}>}Amount)/$(Columndim89)*-1/1000, $(ColumnDim101))),

But not working.

I expect chart to display 600K , which is same as Table 1.

Paul

Re: My chart 2016 bar display when i select compute eXP

paulyeo11 — Tue, 29 Mar 2016 13:18:23 GMT

My QV Doc

Re: My chart 2016 bar display when i select compute eXP

jonathandienst — Tue, 29 Mar 2016 13:44:06 GMT

This art of the set expression looks incorrect:

<$(ColumnDim601)={$(ColumnDim601)}>

Are you sure about that? What do you expect it to look like after the $ expansion is performed.

Re: My chart 2016 bar display when i select compute eXP

paulyeo11 — Tue, 29 Mar 2016 23:05:48 GMT

Hi Jonathan

I think my previous example too complex . i recreate a simple one.

Below expression working fine on chart 1 :-

Sum({<eXP={"eXP"}>}Amount)*-1/$(Columndim89)

May i know how to add Aggr into above expression , so that i can comoute overall total amount.

enclosed my QV Doc

Paul