Box Chart with expression 'Sum'

[Black_Hole]

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.

[martinpohl]

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

[Black_Hole]

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.

[Brett_Bleess]

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/...

Hopefully this helps a bit more.

Regards,
Brett