Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
azimabadi
Creator III
Creator III

$ that i want not to work

Hi All,

I have a variable, let's say myVar. I have a straight table that i want to show $(myVar) as the lable of an expression. But i cant write any statement that show $(myVar) as the lable of column.

I will apreciate any idea.

Best Regards

Peyman

1 Solution

Accepted Solutions
azimabadi
Creator III
Creator III
Author

I have solved the problem with this statement:

= '$' & chr(12) & '(myVar)'

charachter 12 is the form feed code and has no visual effect.

Best Regards

Peyman

View solution in original post

10 Replies
swuehl
MVP
MVP

Very interesting,

I assumed that something like

=chr(36) &'(myVar)'

or

=replace('@(myVar)','@','$')

should work, but failed for the label. There must be something special with the label evaluation (like a multiple evaluation), since above expressions for the label as well the original $(myVar) works for the title bar.

Well, I am also stucked.

Maybe one workaround: Add a space between $ and (myVar)

$ (myVar)

as label.

RedSky001
Partner - Creator III
Partner - Creator III

So you want the literal text to be '$(myVar)' for the label header?

Would be usefull to know what you're trying to achieve by doing this.

You can put the text '$(myVar)' inside the variable myVar to do this, don't think this is what you want though...

Mark

azimabadi
Creator III
Creator III
Author

Hi  swuehl,

thank you for answer. i think a space between $ and ( is what i can use if i find no other solution. Please let me know if you have faound any thin else.

Best Regards

Peyman

azimabadi
Creator III
Creator III
Author

Hi Mesheraton,

Thanks for answer. but i have another value in this variable that i need to keep it.

Best Regards

Peyman

azimabadi
Creator III
Creator III
Author

I have solved the problem with this statement:

= '$' & chr(12) & '(myVar)'

charachter 12 is the form feed code and has no visual effect.

Best Regards

Peyman

Not applicable

Hi,

i've never faced a thing like that.

Could you please tell us what you expect to see on the label? I mean, you can write it down as example.

Thank you

Giampiero

swuehl
MVP
MVP

Good idea!

But chr(12) is giving a symbol at my side (looks like the female sign), I needed to use chr(10) or chr(13) (but these may interfere with wrap header setting) and ended up with chr(9).

Regards,

Stefan

azimabadi
Creator III
Creator III
Author

Hi giampiero,

here in our firm, everyday i face problems like no others .

I think it's the same for most of QV developers.

You can check my example file that is attached.

Best Regards

Peyman

azimabadi
Creator III
Creator III
Author

@Swuehi : i think every control charachter can be used. in my PC 9, 11, 12 works good!

Best Regards

Peyman