Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am importing an Excel table into Qlikview, as per the below extract;
Area | Measure | Year | Jan | Feb |
---|---|---|---|---|
ABC | Value | 2014 | £1,234,766 | £2.367,720 |
ABC | % | 2014 | 2.1% | 3.3% |
DEF | Value | 2014 | £3,331,755 | £2,776,637 |
DEF | % | 2014 | 1.9% | 4.8% |
In the front end of my report, I am creating a pivot table out of this data and need all of the figures to maintain the same format as they have in the source file - so there should be a mixture of £ values and % values.
However, I can't see if there's a way of having multiple number formats per expression (in my case, an expression would be sum(Jan), sum(Feb) etc., with Area, Measure and Year as the dimensions).
Is there a way of doing this at all?
Any help much appreciated!
Hi,
You can use NUM() function with condition to specify desired no format.
Hi,
You can use NUM() function with condition to specify desired no format.
Hi,
try
FindOneOF()
like
if(findOneOf(FieldName,'%')>0,num(fieldName,'#,#0.0%'),num(fieldName,'£#,###,#00'))
Regards
Thanks Sushil - I added an if statement into my expression and used the NUM function within this