This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have an expression which might deliver a financial value which I'd like to display as '£##0' OR a percentage value, I'd like to display in the format '##%'.
Can I do this with expression attributes ?
tresesco idea is what I would do also. However, maybe slightly more efficient (esp if <exp> is complex) would be:
Num(<Exp>, If( <YourCondition>, '##%', '£##0' ) )
View solution in original post
What do you mean when you say Expression attributes?
If( <YourCondition>, Num(<Exp>, '##%'), Num(<Exp>, '£##0' ) )