topic Box Chart with expression 'Sum' in QlikView

Box Chart with expression 'Sum'

Black_Hole — Sat, 16 Nov 2024 19:33:35 GMT

Hello all,

I would like to put in my QlikView dashboard a "box chart" using an expression.

The expression is detailed below:

=if(Len(InvoiceNo)=0, sum(CreditsAmount),sum(DeditsAmount))

(The result to display is equal to the sum of Debits and Credits.

Please could you tell me if I can do that using just a box and not a table box.

Thank you in advance for your help.

Re: Box Chart with expression 'Sum'

martinpohl — Fri, 29 Nov 2019 10:47:24 GMT

with your expression there is a problem that the if-condition is a geenral condition (not addressed to one line)

so you need to calculate this line by line (invoiceno by invoiceno)

=sum(aggr(if(Len(InvoiceNo)=0, sum(CreditsAmount),sum(DeditsAmount)),InvoiceNo))

Regards

Re: Box Chart with expression 'Sum'

Black_Hole — Fri, 29 Nov 2019 12:57:30 GMT

Hello @martinpohl ,

Thank you for your reply.

So, If I have an general conditional then I cannot use a box to display the total reusult of this expression.

Is it that ?

Thank you in advance for your help.

Re: Box Chart with expression 'Sum'

Brett_Bleess — Tue, 10 Dec 2019 20:07:46 GMT

You can try the Text Object, but you likely need to make a selection somewhere to get the expression you have to calculate, whereas the one the partner gave you is based upon Set Analysis, so things will calculate with no selections...

Here is a Design Blog post on Set Analysis as well as the Help link below that:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Hopefully this helps a bit more.

Regards,
Brett