Count Customer Code on X-axis - Page 2 - Qlik Community

Report Inappropriate Content · ‎2014-01-30

how to use calculate dimension so as to have count of customer codes on x-axis.

Report Inappropriate Content · ‎2014-01-31

please advise guys

Report Inappropriate Content · ‎2014-02-01

Please advise Guys..

Report Inappropriate Content · ‎2014-02-01

Help Guys

Report Inappropriate Content · ‎2014-02-01

please advise

agilos_mla · ‎2014-02-01

Count # Customers giiving 80% of Sale

=sum(aggr(if(RangeSum(Above(sum([Actual Sale])/Sum(TOTAL [Actual Sale]), 0, RowNo()))<=0.8,1, 0), [Customer Code]))

michael

Report Inappropriate Content · ‎2014-02-01

it says"

Allocated Memory exceeded......:(

agilos_mla · ‎2014-02-01

Strange, you are 32 bits?

I attached you sample with the text box counter.

Try it !

Report Inappropriate Content · ‎2014-02-01

No we are 64 bits

Report Inappropriate Content · ‎2014-02-01

when I am applying the command into dimension, it says "Allocated Memory exceeds"

agilos_mla · ‎2014-02-01

Sure, you cannot use an aggregation fucntion in the dimension.

Use the option text in chart (in Presentation tab) and add the formula within, then move the result where you want. with CTRL+Shift