topic Code Functionality in QlikView

Code Functionality

Tue, 25 Aug 2015 06:51:47 GMT

Can anyone explain me what is the below code doing

if(Cashflow_Amount<0,'#,##,##,##0;(#,##,##,##0)','#,##,##,##0;#,##,##,##0')

Regards,

keerthi KS

Re: Code Functionality

jonathandienst — Tue, 25 Aug 2015 06:58:55 GMT

I assume that this is a fragment of an expression. It returns a format string; selecting the first at the total row if the Cashflow_Amount is negative.

However, I suspect that it does not work because the naked* field Cashflow_Amount probably cannot evaluate at a total level; so the condition will always be false, and it will always return the "else" condition.

* a field without an aggregation function like Sum(), Avg(), Min()....

Re: Code Functionality

Kushal_Chawda — Tue, 25 Aug 2015 06:58:59 GMT

It's just formatting the numbers based on the Dimension.

Here, Dimensionality()=0 refers to First Dimension of the Pivot Table.

So when you do collapse all to First Dimension and (Dimensionality()=0 and Cashflow_Amount<0) condition satisfied then format the number as '#,##,##,##0;(#,##,##,##0)' and when you do expand all format the number as '#,##,##,##0;#,##,##,##0'

Re: Code Functionality

Tue, 25 Aug 2015 07:05:59 GMT

Oh ok.

Here if the format is '#,##,##,##0;(#,##,##,##0) then negative values comes within braces else number right