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 2 variables defined,
if(Sum($1)/1000000 >= 1, Num((Round(Sum($1)/1000000,.1))) & 'M',
if(Sum($1)/100000 >= 1, Num((Round(Sum($1)/1000,.1))) & 'K', Sum($1)/1000))
vES=< result of some number>
how do I structure the syntax to pass vES into vNumDisplay in a text box ?
- all above do not work ???
View solution in original post
Remove the second dollar-sign:
did not work ...
I think you need the $ sign, but like this (at least that is how I have always done it):
But in this case, when vES is expanded into the expression in vNumDisplay, it must make legal and semantic sense in a Sum(). I don't think a value is expected here.
Actually it worked very well for me - in the context I used it. So probably you used it in another context where it didnt work. But that is how the harder to understand parts of QlikView often works - it is very context sensitive...