Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a model with an income statement in a chart using a UDR
When i export to excel the figures in brackets - the negatives come through as text... I need them to come through as a number
is there perhaps a way to convert this in excel? i think it would be easier for me to show my end user how to do this instead of change all my expressions
I have attached the file ...
In expression use Fabs for ignore negative values
Sum(Metrics) * -1 //if there are only ( - ive )values
this is qlikview syntax?
Yes these are the qlikview syntax's
Sum(Metrics) * -1
although I was looking to solve the issue in excel
I have changed my expressions and solved the issue